Browse by Tags

SQL Server troubleshooting tools PSSDiag, SQLDiag, SQLNexus, RML Utilities and ReadTrace: which one to choose?

Published 5 June 8 2:50 AM | SSQA.net

Not alone with SQL Server you would be able to identify the root cause of a performance issue or to monitor any kind of activity. As you may be aware SYSMON (PERFMON) and PROFILER will help to some extent of finding offending processes on the SQL Server...

Filed under: sql server, profiler, performance, tools, troubleshoot, utilities, ostress, pssdiag, readtrace, sqlnexus, versions, RML utilities

SQL Server 2005 BI evaluate and diagnose Analysis Services database performance

Published 18 February 8 3:57 AM | SSQA.net

Performance - one word does it all! You are aware that during the Performance Tuning exercise there are few quick wins within the SQL Server Relational Database Engine such as table statistics for data and indexes. When it comes to Analysis Services Read...

Filed under: sql server, profiler, performance, databases, security, process, sysmon, administrator, Analysis Services, diagnose

Live Meeting - Advanced Tips and Techniques for using SQL Server 2005 Profiler

Published 17 August 7 5:21 AM | SSQA.net

Upcoming PASS SIG LiveMeeting - August 22, 2007 @ 12:00 p.m. EDT DBA Special Interest Group presents speaker Brad McGehee Brad will be giving a presentation about SQL Profiler. To read a description of the LiveMeeting, the Biography of Brad McGehee, or...

Filed under: sql server, profiler, performance, webcast, microsoft, pass, live meeting

Table fragmentation, Index contention and locking issues to resolve

Published 31 July 7 9:31 AM | SSQA.net

Yet another important factors that every DBA needs to concerned about table & index fragmentation within their SQL Server environment. Refer to the a rticle about DetectTableFragmentation in both 2000 and 2005 version. Fragmentation occurs due to...

Filed under: sql server, profiler, performance, blocking, trace, process, table, locking, loss, fragmentation

Having 'black-box' recorder for SQL Server!

Published 2 July 7 3:34 AM | SSQA.net

Say you have a serious performance problem and few times you will have assertion issue with a dump files creation, in real world say this can be matched to a airplane crash. Where you will know the sequence of events from Black-box records in the flight...

Filed under: sql server, profiler, performance, msdn, blogs, trace, black-box

SQL Server 2005- Is it possible to schedule Data Tuning Advisor?

Published 15 June 7 8:32 AM | SSQA.net

I came across interesting post in SSP looking for a way of automating the Database Tuning Advisor tool of SQL Server 2005 with the help of SQLServer Agent. As the originator looking to schedule it on a regular basis to scan a trace (Profiler) file and...

Filed under: sql server, profiler, performance, tuning, database, dta

Stored procedures performance issues

Published 8 May 7 5:57 AM | SqlServer-QA.net (SSQA)

Every now and then I tend to see lot of questions such as "We have a web application which interacts with SQL Server through Stored Procs. Every so often it seems the response time for an individual Stored Proc will go from a few seconds to a few...

Filed under: sql server, package, stats, perfmon, profiler, performance