Watching SQL server

[Deep Structure Mosey]

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

[Simon Hayes]

Re: Watching SQL server

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" <john@mosey.com bat> wrote in message
news:bda75s01ev j@drn.newsguy.c om...[color=blue]
> 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)[/color]
more[color=blue]
> cloely.
>
> Weely/daily/monthly reporting, etc.
>
> I am wondering if there is something like webtrends for SQL server. i.e.[/color]
what[color=blue]
> queries were called (or even tables), what stored procedures, how much[/color]
bandwidth[color=blue]
> was used, what the average return time, how much data was returned (in[/color]
rows and[color=blue]
> 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[/color]
can[color=blue]
> keep a "long graph" for a day and save it somewhere (even better if it can[/color]
tell[color=blue]
> me what query was run at spikes, etc).
>
> I am coming up empty looking for tools (is one built into SQL server?) but[/color]
I[color=blue]
> can't be the first person with this question.
>
> John Mosey |..X..|....|Bre w-o-meter
> Exalted Grand Puba: http://www.fantasybaseballnews.com/
> "...you look at slugging percentage and on-base percentage. I have a hard[/color]
time[color=blue]
> with that. I have a really hard time with that. I might be wrong, but I[/color]
have a[color=blue]
> hard time with it." .232/.277/.296 player and Twins manager Ron Gardenhire
>[/color]