Performance Tuning

External Article

SQL Server Performance Monitor

  • Article

You can monitor the system performance by using the Performance monitor console and its related counters in Windows 2000. These counters allow you to view or save information about the overall performance of your server. When you install Microsoft SQL Server, additional Performance monitor objects and counters are automatically installed. While you must have administrative access to your SQL Server to use these objects, SQL Server admins should find them invaluable in monitoring and tuning the database server. Furthermore, the Performance monitor can be used either locally or remotely, which allows admins greater control in monitoring SQL Server.

2005-07-01

3,715 reads

SQLServerCentral Article

Real World Query Plans

  • Article

The SQL Server 2000 Query Optimizer is one of the more complicated things that a SQL Server DBA deals with. For most of us, we just let it work and do not give it a second thought. But when a crisis occurred, Andy and Steve had to dive in to learn a few more things about it.

4 (1)

You rated this post out of 5. Change rating

2005-06-09

7,036 reads

External Article

SQL Server Performance Monitor

  • Article

You can monitor the system performance by using the Performance monitor console and its related counters in Windows 2000. These counters allow you to view or save information about the overall performance of your server. When you install Microsoft SQL Server, additional Performance monitor objects and counters are automatically installed. While you must have administrative access to your SQL Server to use these objects, SQL Server admins should find them invaluable in monitoring and tuning the database server. Furthermore, the Performance monitor can be used either locally or remotely, which allows admins greater control in monitoring SQL Server. I am going to show you how to use the Performance monitor to keep a close watch over your SQL Server systems.

2005-05-31

4,010 reads

SQLServerCentral Article

Bookmark Lookups

  • Article

Building high performance applications with SQL Server can be a challenge if you do not understand how the query processor works and how the server uses indexes. SQL Server expert Randy Dyess brings a look at how bookmark lookups are used when satisfying a query and how this can impact the performance of your query.

4.48 (31)

You rated this post out of 5. Change rating

2008-07-18 (first published: )

38,897 reads

Blogs

T-SQL Tuesday #191: Invitation–Your Favorite String Parsing

By

It’s that time of the month, and I’m late. My apologies. I had a...

Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution

By

For decades, enterprises have approached data management with the same mindset as someone stuffing...

Truncate Table Pitfalls

By

 Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....

Read the latest Blogs

Forums

PWDCompare

By Steve Jones - SSC Editor

Comments posted to this topic are about the item PWDCompare

The Improvement Limit

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Improvement Limit

Migrate SSRS Reports to a New Server in Just a Few Clicks

By Kunal Rathi

Comments posted to this topic are about the item Migrate SSRS Reports to a...

Visit the forum

Question of the Day

PWDCompare

What does the PWDCOMPARE function do?

See possible answers