Browse by Tags

• blocking
• contribution
• databases
• long
• parallelism
• running
• statistics
• stats
• stored procedure
• tsql
• tuning

TSQL to obtain a list of current execution of Parallel Plans (MAXDOP)
04 September 07 07:32 AM | SQL Master | 2 Comments   

PARALLELISM is a close friend of DBA where you get to see it as a common occurence in the multi-processor server environment and during such performance issues you can also investigate whether a parallel plan is in use. For instance If a particular query Read More...

Filed under: sql server, performance, query, blocking, stored procedure, statistics, tuning, stats, parallelism, contribution

TSQL to detect long running queries against the database
29 August 07 04:37 AM | SQL Master | 3 Comments   

When I'm performing a performance analysis on a 24/7 application and dealing with PSS I had been given the following TSQL to identify the long running queries against a database. select r.session_id, s.host_name, s.program_name, s.host_process_id, r.status, Read More...

Filed under: tsql, sql server, performance, databases, query, running, long