Browse by Tags

• bottleneck
• contention
• ddl
• expensive query
• identity
• microsoft
• power shell
• reads
• scheduler
• schema
• sql server
• sqlos
• system resources
• technet
• top
• tsql
• writes

SQL Server 2005 DMV - quick information to find resource allocation & DDL bottleneck
09 June 08 01:29 AM | SQL Master | 2 Comments   

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

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

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

List the wait resources and scheduler waits from OS
24 July 07 04:01 AM | SQL Master | 1 Comments   

Got the below script from PSS when we were dealing with a support case to identify the root cause for Scheduler errors during a performance loss & exception errors exercise: select scheduler_id, current_tasks_count, runnable_tasks_count, current_workers_count, Read More...

Filed under: performance, schema, dmv, sqlos, scheduler, power shell