Browse by Tags

• dmv
• execution
• expensive query
• identity
• list
• microsoft
• query plan
• reads
• showpan
• sql server
• system resources
• technet
• writes
• xml

Identifying top 20 most expensive queries in terms of read I/O (referred from Technet Magazine)
15 November 07 06:16 AM | SQL Master | 2 Comments   

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 & Read More...

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

Show text from sql_handle
04 October 07 03:50 AM | SQL Master | 2 Comments   

Based upon the query or stored procedure execution the plan will be stored in the cache, but it may not be in readable format as it is stored in Hexadecimal when you simply query SYSPROCESSES table. So in order to extract the query plan that is in cache, Read More...

Filed under: tsql, sql server, performance, xml, execution, query plan, top, showpan, list