Sometimes, JobTraQ’s database queries time out because of other activity that is slowing down the database server. When this happens, JobTraQ software can gather information about the other activity on the server so that our support team can analyze it for problems. However, it cannot gather this information unless it is given access to the database server’s state. To give JobTraQ permission to gather this information, follow these steps:
- Open SQL Server Management Studio and connect to your database server as a server administrator.
- Find the name of the JobTraQ database admin account. This is usually JobTraQ_Admin.
- Open a new query window.
- Run this command: GRANT VIEW SERVER STATE TO JobTraQ_Admin
(replace JobTraQ_Admin with the correct username)
Once this permission is granted, you can close SQL Server Management Studio. The next time a timeout error happens, JobTraQ software will gather the information that it needs and send it to our support team.