Friday, December 24, 2010

Server Side trace

›
Most of us are aware of tracing queries using SQL profiler. But an effective way of performing tracing is using a server side trace. Whats s...
Wednesday, December 8, 2010

Perfmon counters list - Quest poster

›
Stumbled upon this PDF from quest which lists the important Perfmon counters and their acceptable values. A must print and stick poster wh...
3 comments:
Monday, November 29, 2010

Lock escalation : SQL Server 2008

›
Lock escalation is a event which occurs when SQL Server decides to upgrade a lock at a lower level hierarchy to a lock to a table level lock...
11 comments:
Tuesday, November 16, 2010

Backup log Truncate_Only in SQL Server 2008

›
BACKUP   LOG   < db_name >   WITH   truncate_only command, used for clearing the log file, is deprecated in SQL Server 2008. So thi...
Tuesday, November 9, 2010

Finding CPU Pressure - dm_os_schedulers DMV

›
The last post dealt with checking CPU pressure using wait_stats DMV. But, to get a complete picture of CPU Pressure, the script provided in...
1 comment:
Sunday, October 31, 2010

Finding CPU Pressure using wait_stats DMV

›
CPU Pressure forms vital part in performance monitoring and sys.dm_os_wait_stats is a good place to check. Some background info before we ...
5 comments:
Saturday, October 23, 2010

Backup path

›
Sometimes after taking a backup, one can forget the path where the backup was taken. The simple script below provides the list of backups ta...