Browse by Tags

• analysis
• long
• perfmon
• performance
• query
• running
• SQL Server
• sysmon
• tuning

• TSQL to detect long running queries against the database

  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... Posted Wednesday, August 29, 2007 9:37 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, databases, query, tsql, running, long

• How to Analyze the PERFMON (SYSMON) data?

  As you may aware the PERFMON (SYSMON) utility provides much information to analyze on the systems resource usage, I support and suggest to make use of this tool as much as you can with a default templates within our environment. You may be aware the data Read More... Posted Tuesday, August 21, 2007 4:26 AM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, databases, tsql, analysis, tuning, sysmon, perfmon