Browse by Tags

SQL Server: How do I identify the queries that are worth tuning?

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

Have you ever asked this question about how do I identify the queries that worth tuning? The simple answer it is neither easy or hard to obtain such information if you have managed your SQL Server by deploying industry best practices (wherever possible...

Filed under: sql server, performance, management, microsoft, blogs, technet, dmv, dba, best practice, slow query

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