The general best practice is only capture the events and columns you need when using SQL Server Profiler. But how much impact does it have?
Category: Performance Tuning
Slow disk write performance when you use a back-end SAN on a computer that is running Windows Server 2008 R2
Interesting fix was released today, your WRITE performance might be poor due to incorrect priority in DPC in Windows 2008 R2. If you have write
Getting List of Top Queries by Query Hash
Starting SQL 2008, we have had Query Hash column in sys.dm_exec_query_stats. It helps group common queries together, because when SQL Server is generating execution plan
How to implement PAL (Performance Analyis of Log) counters in Windows 2003?
How to implement PAL counters in Windows 2003?
How to find out what is causing page splits?
Client was noticing high number of Page Splits/sec in relation to Batch Request/sec; however could not figure out why. They were not have performance issue but
How to troubleshoot Writelog wait type?
Few weeks ago when I was teaching the SQL Server PTO Workshop, I didn’t do a deep dive into how to troubleshoot writelog wait type. Before I
SQL Canada (SQLCAN) 