Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 306
  • Last Modified:

Looking for a MS SQL analyser!

Hi,

I am looking for a MS SQL analyser for 7.0 and 2000.

Thanks

JL
0
jlislo
Asked:
jlislo
1 Solution
 
Éric MoreauSenior .Net ConsultantCommented:
Install the Client Utilities from your SQL CD.
0
 
jlisloAuthor Commented:
Is that give you like
1. Usage on CPU break down by DB
2. Usage on each query
3. Summary by DB, user, CPU ...etc
4. Statistic report on each detail

Thanks.
0
 
jlisloAuthor Commented:
Is that give you like
1. Usage on CPU break down by DB
2. Usage on each query
3. Summary by DB, user, CPU ...etc
4. Statistic report on each detail

Thanks.
0
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
wensinkgCommented:
You can get some of what you seek from the Profiler in SQL Server and some of it from the System Performance Monitor from your server.  However, I don't know of any tool that can break down the CPU usage by DB.
0
 
jlisloAuthor Commented:
I think I will try the following two first.

Spotlight vended by Quest Software
LOG EXPLORER from Lumigent

Please let me know if you know any other good one. Thanks.

JL
0
 
David ToddSenior DBACommented:
Hi,

Maybe not for SQL 7, but if you want a non-tool way to do this for SQL 2000 then install each production database into their own named instance of SQL 2000. Then each will have a separate process ID in Task Manager and Performance Monitor.

And assuming no schema changes etc then the system databases will have little or no activity except that generated from your production database.

Of course this might be a bit over the top for what you want ...

Regards
  David
0
 
jlisloAuthor Commented:
You are right this is a little over what I want. I think I will pick one of my list and buy it. But you idea is good, I may use it to one of my most importent DB. Thanks.

Jammy
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now