SQL Server PerfMon counters for tracking Windows memory

SQL Server PerfMon counters for tracking Windows memory

SQL Server PerfMon counters for tracking Windows memory

Date: Mar 05, 2008

Some Performance Monitor (PerfMon) counters are more useful to SQL Server DBAs than others. In part one of this screencast series, SQL Server MVP Kevin Kline walks you through significant PerfMon counters for tracking Windows memory. Here you'll learn how to avoid memory pressure in your SQL Server system by knowing the maximum numbers to be aware of when using PerfMon counters.

More on Microsoft SQL Server Performance Monitoring and Tuning

  • canderson

    SQL Server PerfMon counters for access methods and buffer manager

    VIDEO - SQL Server MVP Kevin Kline focuses on PerfMon counters for SQL Server and shares best practices for tracking IO intensive access methods and buffer manager activity.

  • canderson

    Monitoring SQL Server disk I/O with PerfMon counters

    VIDEO - As a DBA, you need to understand the I/O of your SQL Server disk subsystem. In part three of this screencast series, learn how to track I/O in your direct-attached storage disks (DASD). Get optimal throughput values to keep an eye on when using Performance Monitor counters for physical disk reads and writes and disk queue length. Kline also shares some best practices you can't afford to miss.

  • canderson

    SQL Server PerfMon counters for Windows operating systems

    VIDEO - SQL Server PerfMon counters can help DBAs troubleshoot and even avoid bottlenecks on Windows operating systems. In part two of this screencast, learn the best practices and maximum values to watch for when using counters to monitor OS performance.

  • Configuring SSRS the easy way

    Tip - Demystify the SQL Server Reporting Services (SSRS) configuration process. Get an overview of this tool and guidelines for how to set up each screen in SSRS from industry professional Roman Rehak.

  • Tips for deploying SQL Azure Federations

    Tip - Reduced SQL Azure pricing, an upgraded management portal, increased database size and the SQL Azure Federations Data Migration Wizard mean multi-tenant and “big data” projects are big possibilities.

  • SQL Server 2012 ‘virtually’ out, Microsoft talks features, licensing

    News - With SQL Server 2012 released in a “virtual launch” this month, Microsoft data platform specialist Mark Kromer tells us what his favorite features of the new release are.

    ( Mar 14, 2012 )

  • Microsoft bulks up SQL Server scalability to rival buff competition

    News - Better SQL Server scalability and lower costs have furthered Microsoft’s reach in recent years, industry observers say, and that’s good, because the competition is big and knows the turf well.

    ( Mar 02, 2012 )

  • Five things in SQL Server not in SQL Azure

    Tip - With the excitement over the cloud, it’s easy to forget that Microsoft’s cloud database, SQL Azure, is not for everyone. Learn the five major differences between SQL Azure and SQL Server.
Back to top