468,291 Members | 1,698 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,291 developers. It's quick & easy.

Watching SQL server

We are quickly moving from a small comapny to enterprise.

As it happens we want to watch SQL server (our bread and butter is data) more
cloely.

Weely/daily/monthly reporting, etc.

I am wondering if there is something like webtrends for SQL server. i.e. what
queries were called (or even tables), what stored procedures, how much bandwidth
was used, what the average return time, how much data was returned (in rows and
total size) etc.

In fact, if this can be done by hour of the day that would be a bonus. (or
concurrent connections through out the day)

Also, is there a tool much the same for Task Manager (Windows 2000) that can
keep a "long graph" for a day and save it somewhere (even better if it can tell
me what query was run at spikes, etc).

I am coming up empty looking for tools (is one built into SQL server?) but I
can't be the first person with this question.

John Mosey |..X..|....|Brew-o-meter
Exalted Grand Puba: http://www.fantasybaseballnews.com/
"...you look at slugging percentage and on-base percentage. I have a hard time
with that. I have a really hard time with that. I might be wrong, but I have a
hard time with it." .232/.277/.296 player and Twins manager Ron Gardenhire

Jul 20 '05 #1
1 2871
You don't mention which version of MSSQL you have, but assuming you have
SQL2000, then you can look at Profiler and the System Monitor SQL Server
performance counters. The BOL section called "Choosing a Monitoring Tool"
gives a pretty good overview of which tool can do what.

There are plenty of third party apps as well, of course, but you can already
get lots of information from Profiler and System Monitor, so they are a good
starting point.

Simon

"Deep Structure Mosey" <jo**@mosey.combat> wrote in message
news:bd*********@drn.newsguy.com...
We are quickly moving from a small comapny to enterprise.

As it happens we want to watch SQL server (our bread and butter is data) more cloely.

Weely/daily/monthly reporting, etc.

I am wondering if there is something like webtrends for SQL server. i.e. what queries were called (or even tables), what stored procedures, how much bandwidth was used, what the average return time, how much data was returned (in rows and total size) etc.

In fact, if this can be done by hour of the day that would be a bonus. (or
concurrent connections through out the day)

Also, is there a tool much the same for Task Manager (Windows 2000) that can keep a "long graph" for a day and save it somewhere (even better if it can tell me what query was run at spikes, etc).

I am coming up empty looking for tools (is one built into SQL server?) but I can't be the first person with this question.

John Mosey |..X..|....|Brew-o-meter
Exalted Grand Puba: http://www.fantasybaseballnews.com/
"...you look at slugging percentage and on-base percentage. I have a hard time with that. I have a really hard time with that. I might be wrong, but I have a hard time with it." .232/.277/.296 player and Twins manager Ron Gardenhire

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by BluDog | last post: by
6 posts views Thread by softwareengineer2006 | last post: by
4 posts views Thread by Dusan Micuch | last post: by
reply views Thread by John Wright | last post: by
2 posts views Thread by Peter Michaux | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.