473,379 Members | 1,422 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,379 software developers and data experts.

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 3132
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Claire | last post by:
Im sat here watching task manager and the memory consumption of my application rising second by second. What tools are there out there for me to use to find where it's all going please? (I wish...
0
by: BluDog | last post by:
Hi I am trying to monitor the users that have active sessions on a small intranet (only about 20 users). I log sessions in and out in an SQL database, what i want is a page that displays the...
2
by: paul | last post by:
Watching connections to your computer. Can some one tell where to start. I want to write some code to be alerted when some one connect to my computer and browses/copies/changes files or...
2
by: Stu | last post by:
Hi, I have been asked to interface with an AIX system running a COBOL application. Not having done this before we settled on text files written to a drive to communicate between the two systems....
6
by: softwareengineer2006 | last post by:
Your Boss is Watching Your Emails!! Find out why and how you should encrypt your confidential emails before sending in my website http://tinyurl.com/z4u8m
4
by: Dusan Micuch | last post by:
Hi, What's best way for Watching my Packet TCP and UDP ? Socket ? Some external DLL ? What I need to use for build programs like this? I want measure data on specific or anyone port at Real Time....
0
by: John Wright | last post by:
Is there a way to monitor SQL Server and detect with it goes off line? I don't want to ping it or connect constantly, I just want to watch for an event that may be fired. If this is not possible,...
2
by: Peter Michaux | last post by:
Hi, Is there any way to watch regular form submission leave the browser? I have a complicated dynamic form to learn about and instead of sorting through the code I would like to see what is...
3
by: canabatz | last post by:
Hi all i got a page that is refreshing data in a grid every 4 seconds and displaying results from the database and check if something as changed! my question is if there is 100 users that is...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.