If you want to find the currently running jobs then following queries will help you. List All Currently Running SQL[…]
Read moreCategory: Uncategorized
SQL Server 2005 -Trouble Shooting Client To Server Connection
Applies on : SQL Server 2005 and above Tested on : SQL Server 2005 1). Check Server Property: 1.1 Right[…]
Read moreSQL Server- Get SQL server Statistics using SP_Monitor
Sp_Monitor : It is a useful system function used to see the statistics of the SQL Server. Following image shows the[…]
Read more
