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?
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
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 counters in Windows 2003?
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
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