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: Creating BlackBox kind of trace with TSQL

Published 28 May 8 6:59 AM | SSQA.net

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

Filed under: sql server, profiler, trace, tsql, size, blackbox

SQL Server 2005 logging providers - make best use for SSIS packages to diagnose the issues

Published 9 April 8 2:22 AM | SSQA.net

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

Filed under: sql server, package, profiler, ssis, xml, error log, 2005, information, warning, logging, event viewer

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

SQL Server 2005 Agent XPs disabled error - how to resolve this issue?

Published 6 February 8 2:38 AM | SSQA.net

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

Filed under: sql server, profiler, security, services, sqlagent, sa, error log, msdtc, group policy

TSQL to create a TraceCollector with a default collection set

Published 24 September 7 5:45 AM | SSQA.net

use msdb declare @schedule_uid uniqueidentifier select @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...

Filed under: sql server, profiler, trace, query, tsql, collation, collecter, collection, msdb

How to use a stored procedure to monitor traces in SQL Server 2005

Published 4 September 7 11:39 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications How to use a stored procedure to monitor traces in SQL Server 2005 http://support...

Filed under: sql server, profiler, trace, kba, process, stored procedure

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

SQLServer2005 Profiler (profiler90.exe) fails to launch with Application Error (0x0000005)

Published 19 June 7 3:16 PM | SSQA.net

Further details and resolution for this problem can be found from this FAQ entry....( read more ) Read More...

Filed under: application, sql server, profiler, error log

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