Solved

PerfFormattedData entries are not exists for MSSQL Server

Posted on 2008-10-09
3
608 Views
Last Modified: 2012-05-05
I need to track some performance counters,
there are some PerfRawData entries exists, but why
corresponding PerfFormattedData entries are not exists for my MSSQL Servers (2005 and 2008)?
0
Comment
Question by:Cedric_D
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 31

Expert Comment

by:James Murrell
ID: 22733839
unsure have you looked at
http://bytes.com/forum/thread254788.html
0
 
LVL 7

Author Comment

by:Cedric_D
ID: 22742076
Additional note: PerfFormattedData for OLAP instance created well:
Win32_PerfFormattedData_MSOLAPSSSS_MSOLAPSSSSCache
but not
Win32_PerfFormattedData_MSSQLSSSS_MSSQLSSSSBufferManager


For RowData all is OK, and all counters successfully viewable in PerfMon:

Win32_PerfRawData_MSOLAPSSSS_MSOLAPSSSSCache
Win32_PerfRawData_MSSQLSSSS_MSSQLSSSSBufferManager



0
 
LVL 7

Accepted Solution

by:
Cedric_D earned 0 total points
ID: 22765884
I've found a reason, already.
These counters appear only at Windows 2003 Server, not at XP Pro.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question