MS SQL Server tuning is very similar to any other powerful Database Management System (DBMS), with similar performance and tuning considerations. For example: 1. How effective are the memory-resident database buffers at reducing disk I/O? 2. Where have you placed the database transaction recovery log files? 3. Does the database design minimize contention for SQL […]
Archive for FAQ
Where are my SQL Server 2000 counters?
Beginning with SQL Server 2000, performance objects are named differently depending on whether you are running a single, unnamed instance of SQL Server or either a named instance or multiple instances of SQL Server. If you are installing SQL Server on a machine that is also running a previous version of SQL Server, then you must install […]
How does the Module filter work?
Unless you are prepared to deal with much larger Performance Sentry data files than usual, you should use appropriate filter settings when you collect Module data. Collecting the Module information is costly, and the average Windows Server executable routinely loads 50-100 assorted DLLs. Please be careful with this new function and implement a Module filter […]
What does the Module collection function do?
A performance data Object called Module is created internally, when you include the Module Object in your Data Collection Set (DCS) data definition. Each instance of the Module Object shows a load module name, usually a DLL (dynamically linked library module) that is loaded within the specific process. The Module Object also has a parent […]
What is the meaning of the message “Insufficient data in performance name table” in the NTSMF.LOG File?
Sometimes the following message is displayed in the “.Log” file: 04/14/08-13:44:04 – Event ID: 2900, Category: Perf Text, Severity: Error Insufficient data in performance name table or 05/17/16-00:00:05 – Event ID: 2902, Category: Perf Text, Severity: Warning Name table located at \windows\system32\perfc009.dat. The following areas of the name table could not be interpreted which could […]
Why is Performance Sentry not collecting a specific performance counter (or counters) that I need to look at?
There are a number of reasons why Performance Sentry may not be collecting some performance Counter or Counters that you need to look at. Sometimes the reason is fairly trivial and easy to rectify. Sometimes the reason is more difficult to determine. Sometimes, it is a problem with the Performance Sentry collection service itself, which we want you […]
Is Performance Sentry compatible with the Microsoft Cluster Server?
Yes. Microsoft Corp. defines a server “cluster” as a group of independent servers managed as a single system for higher availability, easier manageability and greater scalability. The minimum requirements for a server cluster, according to Microsoft, are (a) two servers connected by a network, (b) a method for each server to access the other’s disk […]
What do I need to do to get started with Performance Sentry?
Installation is a three-step process: 1. Prepare the machine you want to use to administer Performance Sentry. Run the Setup program contained on the installation disk to install the Sentry Administration program on the Windows workstation or server you intend to use to administer Performance Sentry. Sentry Administration is used to define and activate performance […]
Is Performance Sentry easy to install?
Easy as pie. The standard installation package that we ship contains three separate Setup routines that can be run separately or together. One setup routine is used to install the Sentry Administration GUI which is used to administer NTSMF data collection. You can install as many copies of the Sentry Administration program as necessary to […]
What is Performance Sentry and how does it relate to NTSMF?
Performance Sentry was originally created as NTSMF. Demand Technology Software was founded in the early days of Windows NT by mainframe performance analysis and capacity planning professionals. They recognized the need for capturing performance metrics on Windows NT in a fashion similar to the mainframe software called SMF (System Management Facility). Thus, Windows NT SMF […]
Explore the Site
From the Blog
- Windows Performance and Capacity Planning Challenges in Virtualized Environments
- Defining and Using Machine Groups in the Performance Sentry PDB
- Microsoft’s Hyper-V Performance — Introduction
- Performance Sentry Cumulative Maintenance Released
- Demand Technology Software Announces v2.4 of the Performance Sentry Web Portal
- Performance Sentry VM 2.0 now available
- Performance Sentry supports Windows Server 2012 R2 and Windows 8.1
- New Performance Objects in Windows 8 and Server 2012
- MXG and Performance Sentry for Cost Effective Windows Performance Monitoring
- Performance Sentry supports Windows Server 2012 and Windows 8
- Performance Sentry Performance Database (PDB) Data Model
