I am trying to monitor performancce of a database using PerfMon, but the
database instance does not show in PerfMon. I have noticed that some
databases show up in the list and some don't. These database are all active
and running. Why is this?This is a multi-part message in MIME format.
--060202050209050201010409
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Do you have more than 99 DBs on your SQL instance (including master,
model & tempdb)? SQL used to have a problem keeping perfmon stats for
dbids > 99. I don't know if Microsoft have fixed that issue with SQL
2005 or not. If that's what's happening with you then in perfmon you'll
see DBs whose dbid() <= 99 but not those DBs over that.
--
*mike hodgson*
http://sqlnerd.blogspot.com
Paul wrote:
>I am trying to monitor performancce of a database using PerfMon, but the
>database instance does not show in PerfMon. I have noticed that some
>databases show up in the list and some don't. These database are all active
>and running. Why is this?
>
--060202050209050201010409
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Do you have more than 99 DBs on your SQL instance (including
master, model & tempdb)? SQL used to have a problem keeping
perfmon stats for dbids > 99. I don't know if Microsoft have fixed
that issue with SQL 2005 or not. If that's what's happening with you
then in perfmon you'll see DBs whose dbid() <= 99 but not those DBs
over that.</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
Paul wrote:
<blockquote cite="midFDAEF3DA-76A8-4A36-920B-36D6E7DCFB0D@.microsoft.com"
type="cite">
<pre wrap="">I am trying to monitor performancce of a database using PerfMon, but the
database instance does not show in PerfMon. I have noticed that some
databases show up in the list and some don't. These database are all active
and running. Why is this?
</pre>
</blockquote>
</body>
</html>
--060202050209050201010409--
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment