SqlServer-QA.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 for further fine tuning for queries or tasks. Still there is a need to dig deeper on the ...

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 (BI) database then no difference as one of the greatest enhancements in Analysis ...

Upcoming PASS SIG LiveMeeting - August 22, 2007 @ 12:00 p.m. EDTDBA Special Interest Group presents speaker Brad McGeheeBrad will be giving a presentation about SQL Profiler.  To read a description of the LiveMeeting, the Biography of Brad McGehee, or get the details on how to attend, click here.

Yet another important factors that every DBA needs to concerned about table & index fragmentation within their SQL Server environment. Refer to the article about DetectTableFragmentation  in both 2000 and 2005 version.   Fragmentation occurs due to updates and delets on the table and the golden rule is that ...

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 to investigate, similarly how about having such facility ...

If a particular query is performing poorly the first thing you would check is relevant indexes, even though having associated indexes against those tables may not help any better to the performance. The next phase you observe is high CPU count from the Task Manager (TM), up to some extent using TM is useful but never come into conclusion that ...

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 export the results to a file. I believe this is a good way to avoiding any manual ...

Achieving the performance for slow running queries is not a rocket science to understand. The database performance is dependant on implementing optimum database design with sensible hardware-based configuration and capacity planning. So how you can identify where the performance is degraded, say when you desing it is easy to identify the large ...

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 minutes. What is best way to determine cause? First thing to check is do you have ...