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

Here is the kind of scripts defined within TEchnet articles about running black-box kind of traces against your SQL Server instance, then also you can  take advantage of the blackbox trace if you are facing intermittent problems, you want to make sure that it is always running when your server is running—including after either a planned ...

Log or trace of activities will help you to get detailed information on what's going wrong, that too very useful for ETL based processes. In this regard within SQL Server 2005 using SSIS you can enable such logging within the package's  runtime.   This will allow you to log the output to 5 providers, such as text ...

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

When SQL Server 2005 Management Studio's Object Browser shows the SQL Server Agent service with a red down arrow and the text Agent XP's disabled, the service is not started or disabled. This used to be a problem prior to Service Pack 2 for SQL Server 2005, obviously SQLAgent is important part of SQL Server tasks that you need to schedule on ...

use msdbdeclare @schedule_uid uniqueidentifierselect @schedule_uid=(select schedule_uid from msdb..sysschedules where name=N'CollectorSchedule_Every_15min') declare @collection_set_id int;exec dbo.sp_syscollector_create_collection_set    @name = N'SqlTraceDefault',    @schedule_uid = @schedule_uid,  -- 15 ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise EditionNotification Contents: New and Major Modifications How to use a stored procedure to monitor traces in SQL Server 2005http://support.microsoft.com/kb/912914/en-US

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