| Author |
Topic |
|
MediaPirate
Yak Posting Veteran
52 Posts |
 Posted - 2003-09-11 : 13:26:07
|
| I'm trying to monitor transactions/sec with Win2k Perf monitor. However, I noticed not all of the SQL databases are listed. Does anyone know why this is? and how I can get them all? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-11 : 13:29:40
|
| They are all listed in my Performance Monitor. I guess it could be a permissions problem or maybe the state of the database doesn't allow it to come up. Is there anything different with this database? Does your account have admin on the local box and does the BUILTIN\Administrators group have sysadmin in SQL Server?Tara |
 |
|
|
MediaPirate
Yak Posting Veteran
52 Posts |
Posted - 2003-09-11 : 13:31:55
|
| Tara- I'm login in as a sysAmin user, I can see the majority of the databases. The problem is, the one I need to see I cannot. I'll mess with the permissions to see if that's the problem. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-11 : 13:37:15
|
| If permissions or the state of the database isn't the problem, then I would check to see if you have the latest service packs for SQL Server and Windows.Tara |
|
|
|
MediaPirate
Yak Posting Veteran
52 Posts |
Posted - 2003-09-11 : 14:20:33
|
| We're running SP4 for WIN2K and SP3 for SQL2K. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-11 : 14:26:28
|
| Well I'm out of ideas. You might need to call MS to get a resolution for this. Just to be sure though, are you sure that you are connecting to the correct server? Are you sure that the database exists on that server? Is the database name listed when you run this query on the server:SELECT nameFROM sysdatabasesORDER BY nameTara |
|
|
|
MediaPirate
Yak Posting Veteran
52 Posts |
Posted - 2003-09-11 : 17:02:34
|
| These are the extact steps I'm taking:TS into the server as an NT Admin.Open Perf.Mon I'm using local computer counters.Performance Objects: SQLServer:DatabasesSelect instances: One thing I've noticed, it only pulls 100 databases. This server has 350 , but it hits all letters of the alphabet. They can begin with Upper or Lowercase, we don't start db names with #'s. I need to monitor this database, because I have a feeling he's using more resources and than everyone else. Does anyone know of a way to monitor database activity without using Perf.Mon? I can't fork out the $1000 for a decent Auditing package at the moment :-( and I need hard evidence that this guy is using hammering the server so we can get him to a dedicated plan. Thanks, Jim |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-11 : 17:41:18
|
| Not sure what transactions/sec is going to prove though. If someone runs small queries over and over again, the transactions/sec is going to be high. If someone runs CPU intensive queries a few times, the transactions/sec is going to be log. SQL Profiler is another tool to use to track activity.Why don't you install multiple SQL instances instead of putting all of the database in one instance? If you did this, then you could restrict the number of processors and RAM for each of the instances. Each one of your customers could use a different instance and you could then figure out how much CPU each is using by checking the CPU utilization on the exe level.Tara |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-11 : 17:47:23
|
| Ilya,How'd you find the Q article? What did you search on? I searched the KB and couldn't find anything. I must not have been using the right key words.Tara |
|
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2003-09-11 : 17:57:11
|
quote:
Originally posted by tduggan
Ilya,How'd you find the Q article? What did you search on? I searched the KB and couldn't find anything. I must not have been using the right key words.
Wow, that's fast!!!  I didn't think anyone had time to read my message before I deleted it (decided to delete it, 'cause you've managed to snipe me with pretty much the same info). Anyhow, the KB article is http://support.microsoft.com/default.aspx?scid=kb;en-us;330088and I searched on "performance counters sql database" |
|
|
|
|
2000 Perf Monitor missing databases