Browse by Tags

SQL Server 2005 DMV - quick information to find resource allocation & DDL bottleneck

Published 9 June 8 3:29 AM | SSQA.net

Initially I preferred to put this blog post within Performance tuning blog section here, but as it relates to the TSQL script thought this is best place to go. Anyways, if you have a performance problem the foremost option is to find whether the server...

Filed under: sql server, performance, dmv, tsql, contention, ddl, bottleneck

Identifying top 20 most expensive queries in terms of read I/O (referred from Technet Magazine)

Published 15 November 7 7:16 AM | SSQA.net

It is worth mentioning the valueable query I have been through when referring to Technet Magazine, the following query has given me useful information in finding out what are my top 20 most expensive queries that are consuming most of disk I/O (read &...

Filed under: sql server, performance, microsoft, technet, dmv, top, tsql, reads, system resources, expensive query, identity, writes

Usage and good practices with UPDATE STATISTICS feature in SQL 2005

Published 23 July 7 5:39 AM | SSQA.net

UPDATE STATISTICS is very helpful to get the performance by updating the distribution of key values for one or more statistics groups or set of collections in the specified table or indexed view. So how this is handled within the SQL Server, you may be...

Filed under: performance, security, dmv, query, optimization, tsql, statistics, update statistics