Browse by Tags

SQL Server - PERFMON counters and Resource Governor - what you can do in a performance issue situation?

Published 17 November 8 1:41 AM | SqlServer-QA.net

PERFMON and Resource Governor - two great tools in hand for a DBA to monitor/resolve the performance problems, agreee! Back in olden days you may remember about SQLDiag and PSSDiag, the utility used as a general purpose diagnostics collection utility...

Filed under: sql server, perfmon, performance, dmv, dba, sysmon, performance monitoring, resource governor, new feature

SQL Server 2005 DMV - how it can help to consider whether index is useful or not?

Published 4 February 8 8:6 AM | SSQA.net

When it comes to performance, for a DBA indexes are the first one to come to mind in order to fine tune the tasks on the database. In this series we have already covered this huge topic of indexing and how best you can make use of Dynamic Management Views...

Filed under: sql server, performance, indexes, dmv, dba, performance monitoring, index plan

SQL Server Query Performance - think about page split and fragmentation, measures to reduce the behaviour and best use of dm_db_index_physical_stats DMV

Published 14 January 8 2:22 AM | SSQA.net

It is an universal truth in the database field that due to the fragmentation and page split the performance will be affected even for a simple [ SELECT <ColumnName> from.... ] type of query. So what you need to check or take action in terms of DBA...

Filed under: sql server, performance, indexes, maintenance plan, dmv, dba, best practice, performance monitoring, sys.dm_db_index_physical_stats, measures