|
Home > Archive > MS SQL Server > October 2005 > Monitor Data Access Speeds & Time-Outs
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Monitor Data Access Speeds & Time-Outs
|
|
| duvinrouge@servihoo.com 2005-10-20, 8:23 pm |
|
I've been asked to produce charts that show data access & time-out
information for an instance of SQL Server.
I've very little experience with SQL Server.
My background is MI - so only know Analysis Services part of SQL
Server.
It would seem the previous person manually went through error logs
generated & rekeyed appropriate data into Excel to produce charts.
How can I produce the following charts automatically?
1. Data Access - ave. access time per process by day
2. SQL Errors - number of by day
3. Time-outs - number by hour
Or anyway of achieving effectively the same thing without any manual
involvement.
Many thanks.
| |
|
| We probably need more information on what you are trying to collect but here
is a start.
Setup a SQL trace. It will need to run 24hours a day writing to a file(s).
Have it stop and write out every so often 5 mins, 4 hours (depends on system
load and requirements). Start the next trace. Read the trace into a table.
Delete old trace files.
1. Data Access - Assuming you mean how long did each query take to be
serviced. Add RPC:Completed and SQL:Batch Completeed to trace events.
Select the avg(duration) of these events over the time period you need.
2. SQL Errors - Add the specific SQL errors you are looking for in the
trace. Select the cout of them over the time period.
3. Timeouts. Not sure where you are getting timeout information now.
There's lock timeout, remote query time, or connection timeout in SQL
Agent...Need more info.
<duvinrouge@servihoo.com> wrote in message
news:1129629233.565048.215040@g44g2000cwa.googlegroups.com...
>
> I've been asked to produce charts that show data access & time-out
> information for an instance of SQL Server.
>
> I've very little experience with SQL Server.
> My background is MI - so only know Analysis Services part of SQL
> Server.
>
> It would seem the previous person manually went through error logs
> generated & rekeyed appropriate data into Excel to produce charts.
>
> How can I produce the following charts automatically?
>
> 1. Data Access - ave. access time per process by day
> 2. SQL Errors - number of by day
> 3. Time-outs - number by hour
>
> Or anyway of achieving effectively the same thing without any manual
> involvement.
>
> Many thanks.
>
|
|
|
|
|