Archive

Posts Tagged ‘MS SQL’

Reporting Server Error 1053: The service did not respond to the start or control request in a timely fashion


If you have problems starting Reporting Services, the problem may be that the service times out when trying to start.
To fix this problem follow the guide below:

1.  Click Start, click Run, type regedit, and then click OK.
2. Locate and then click the following registry subkey:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control

3. In the right pane, locate the ServicesPipeTimeout entry.

Note If the ServicesPipeTimeout entry does not exist, you must create it. To do this, follow these steps:

a. On the Edit menu, point to New, and then click DWORD Value.
b. Type ServicesPipeTimeout, and then press ENTER.
4. Right-click ServicesPipeTimeout, and then click Modify.
5. Click Decimal, type 60000, and then click OK.

This value represents the time in milliseconds before a service times out.

6. Restart the computer.

Check active queries in MS SQL


Here is an custom query for checking all running queries on an MS SQL server.

the custom writing in this script is just that it runs the sp_who two times and makes an diff on CPU time and DiskIO.

idefix_sql

Download the file under, and run it in MS SQL Server Managmenet Studio.

sp_who2

%d bloggers like this: