Browse by Tags

SQL Server Performance issues with Fragmentation and heavy usage of TEMPDB?

Published 15 May 8 3:59 AM | SSQA.net

Whenever a performance issue occurs on the SQL Server database best option for diagnosing and troubleshooting common problems by using publicly available tools such as Profiler, System Monitor (Perfmon), and Dynamic Management Views (DMVs) in SQL Server...

Filed under: sql server, performance, dmv, best practices, tempdb, monitoring, benchmarking, performance monitoring

Get SQL Server Clustering information with DMVs and SELECT statements

Published 11 March 8 12:16 PM | SSQA.net

Few counters and gotchas for you to look for when you are installing SQL Server clusters, also using SELECT statements & DMVs to get SQL instance information. Such as: Do not install SQL Server on a compressed drive, by default the installation will...

Filed under: sql server, dmv, best practices, cluster, clustering, select, virtual server, nodes, shared drives, serverproperty