Browse by Tags

Site sponsored by:

RSS Feeds

profiler » troubleshoot (RSS)

Need pointers on where to look for database congestion/slowdown

Our SS 2000 database is usually satisfactorily responsive most of the time, but there are times during the day that the response time becomes unacceptible; ie queries that typically take 1 to 8 seconds take longer than 30 seconds. The slowdowns seem to take place hourly for about 10 minutes (like from...

Posted to Performance Tuning for DBAs (Forum) by dbatesx on 07-02-2008
SQL Server troubleshooting tools PSSDiag, SQLDiag, SQLNexus, RML Utilities and ReadTrace: which one to choose?

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

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 06-05-2008
Re: Help scheduling and configuring a Profiler trace

I know its frustating on such client! You could run server side tracing in this case that will minimize impact that might get due in running PROFILER. http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm http://www.mssqltips.com/tip.asp?tip=1035 http://sqlblog.com/blogs/linchi_shea/archive...

Posted to Performance Tuning for DBAs (Forum) by satya on 08-23-2007