Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

James' SQL Footprint

Love SQL Server, Love life.

Archives: March 2012

Monitor SQL Server Backup job duration

if you run BACKUP DATABASE T-SQL, there is a parameter STATS which reports the percentage complete, However when you run the SQL Agant backup job which is created by maintenance plan,  it will be difficult to monitor the percentage of backup process.

here you can use the query below:
==========================================================
SELECT…

Read more

0 comments, 763 reads

Posted in James' SQL Footprint on 31 March 2012

Select : Lock or No Lock?

Here is a post I happen to find today: why select command is not blocked by update command?


First, I thought it might be a transaction isolation level issue, but when I dig into the problem, something interesting pop up.

Here is the script to repro this issue
first create…

Read more

1 comments, 1,197 reads

Posted in James' SQL Footprint on 30 March 2012