Most useful counters for SQL Server performance monitoring

Grok Headline matches for Most useful counters for SQL Server performance monitoring

Counters for Monitoring MOM Performance

Counters for Monitoring MOM Performance 05/26/2004 04:52 PM

Available Performance Monitor Counters
for Discovery Data Record monitoring

Available Performance Monitor Counters
for Discovery Data Record monitoring 07/13/2004 06:47 AM

SQL Server profiling, monitoring and
tuning: SQL Server Performance Objects
(Part 3)

SQL Server profiling, monitoring and
tuning: SQL Server Performance Objects
(Part 3) 05/21/2004 06:44 PM

Some tips on SQL Server server
performance monitoring

Some tips on SQL Server server
performance monitoring 09/26/2004 12:38 PM

Identifying SQL Performance Monitor
Counters

Identifying SQL Performance Monitor
Counters 08/21/2004 12:43 PM

SQL Server profiling, monitoring and
tuning: Choosing the right monitoring
tool … (Part 2)

SQL Server profiling, monitoring and
tuning: Choosing the right monitoring
tool … (Part 2) 07/14/2004 10:04 AM

ACA to start monitoring Hutchison
performance

ACA to start monitoring Hutchison
performance 09/24/2004 03:45 AM
ZDNet Australia Sep 24 2004 7:39AM GMT

Monitoring Disk Activity With
Performance Monitor

Monitoring Disk Activity With
Performance Monitor 04/25/2004 12:41 PM

Launch of a New Generation of email
Server- Unrivalled Performance and Ease
of Administration with Hexamail Server

Launch of a New Generation of email
Server- Unrivalled Performance and Ease
of Administration with Hexamail Server 06/05/2005 11:14 PM
Hexamail Server provides all levels of corporate users and Internet Service Providers with an email server offering unparalleled performance, user-friendly interface and a complete range of features to help system administrators set up a cost-effective, secure and powerful mail server. [PRWEB Jun 2, 2005]

SQL Server Monitoring - II

SQL Server Monitoring - II 01/23/2004 07:37 PM

Internet monitoring app for Mac OS X
Server out

Internet monitoring app for Mac OS X
Server out 06/22/2004 03:44 PM
Vicomsoft has released SuperIntendent, a Mac OS X Server-based solution for the growing market of content monitoring and filtering...

Event IDs to Exclude Monitoring an SMS
Server

Event IDs to Exclude Monitoring an SMS
Server 07/07/2004 11:14 AM

Aplus Launches Server Monitoring Tool

Aplus Launches Server Monitoring Tool 01/06/2005 02:43 PM
theWHIR Jan 6 2005 6:28PM GMT

SQL Server profiling, monitoring and
tuning: System Monitor (Part 4)

SQL Server profiling, monitoring and
tuning: System Monitor (Part 4) 05/26/2004 10:38 AM

Microsoft SQL Server 7.0 databases
monitoring – 1105 / 9002 error
recovering PART1

Microsoft SQL Server 7.0 databases
monitoring – 1105 / 9002 error
recovering PART1 07/08/2004 05:24 AM

SQL Server Performance and Tuning

SQL Server Performance and Tuning 04/15/2004 02:24 PM
DDJ Apr 15 2004 6:46PM GMT

The Petstore Revisited: J2EE vs .NET
Server Performance

The Petstore Revisited: J2EE vs .NET
Server Performance 10/31/2002 01:15 AM
TheServerSide presents a pretty damning report about EJB servers. They compared 2 EJB servers (most likely Weblogic and Websphere) against a .NET server implementation. TheServerSide modified and improved the Java Pet Store blueprint. Unfortunately, the results were pretty dissapointing. In essence, the .NET servers performed at least twice as fast and could handle at least twice the load as compared to the EJB servers.

"tri" Rebuttal by Rickard Oberg.

"zeldman.999"

Zeus Web Server Achieves Performance
Records

Zeus Web Server Achieves Performance
Records 01/22/2004 02:44 AM
theWHIR Jan 22 2004 7:07AM GMT

Troubleshooting Exchange Server 2003
Performance

Troubleshooting Exchange Server 2003
Performance 12/13/2003 09:20 AM
This technical article provides administrators of Microsoft Exchange Server 2003 with information on how to isolate performance degradations and how to use existing tools and products, such as Performance, Load Simulator, Exchange Stress and Performance 2003, Network Monitor, and Filemon, for this purpose. The information in this article can also be used to ensure that a server is not degrading over time because of hardware issues or malfunctions. .

WatchMouse Opens New Monitoring Stations
in China and London - Largest Monitoring
Network World-Wide

WatchMouse Opens New Monitoring Stations
in China and London - Largest Monitoring
Network World-Wide 12/17/2004 06:44 PM
WatchMouse, active in monitoring websites world-wide, has opened two new monitoring stations: in Hong Kong and London. At the same time, the company’s station in Sydney, Australia, has been completely renewed. With this expansion, WatchMouse is responding to the explosive growth in interest in real-time site monitoring from e-commerce companies. With nine stations, the Netherlands-based company is now the largest monitoring network world-wide. [PRWEB Dec 16, 2004]

Modifying Performance Options in Server
2003 using VB Script

Modifying Performance Options in Server
2003 using VB Script 04/27/2004 05:29 PM

Monitoring the International Web -
Website Monitoring Now Available in Four
Major Languages

Monitoring the International Web -
Website Monitoring Now Available in Four
Major Languages 03/14/2005 04:40 PM
The English Web is no longer the only place where businesses interact. Dotcom-Monitor is reaching our to companies in German, Spanish and French to provide website monitoring to them, too. [PRWEB Mar 14, 2005]

SQL Server Health and History Tool
(SQLH2) Performance Collector

SQL Server Health and History Tool
(SQLH2) Performance Collector 09/21/2004 10:17 AM

SQL Server Health and History Tool
(SQLH2) Performance Collector (Version
2)

SQL Server Health and History Tool
(SQLH2) Performance Collector (Version
2) 09/20/2004 10:35 PM
The SQLH2 Performance Collector is a stand-alone service of Microsoft Windows that collects and stores performance counter data from selected servers. You should install this optional component if you are interested in collecting performance counters along with system information. The SQLH2 Collector gathers the data that this service collects and stores this data in the repository when you run the SQLH2 Collector. To obtain the SQLH2 Collector, search the Microsoft download site and search for "SQLH2".

Server and Data Center Consolidation:
Microsoft IT Enhances Availability,
Performance, and Cost Savings

Server and Data Center Consolidation:
Microsoft IT Enhances Availability,
Performance, and Cost Savings 06/17/2004 08:15 AM

Google counters search-fix lawsuit

Google counters search-fix lawsuit 01/13/2003 03:51 AM
Google has moved to quash a lawsuit that alleges the company manipulated search query results, according to a court filing. The ...

Napster counters iTunes with new To Go
service

Napster counters iTunes with new To Go
service 02/05/2005 09:19 PM
Digital music service Napster LLC on Thursday announced the release of Napster To Go, a new Windows-compatible portable digital music subscription service that lets user move an unlimited number of songs from Napster to compatible MP3 players for a US$14.95 monthly fee. A $30 million marketing campaign kicks off Sunday during this year's Super Bowl, and is aimed squarely at Apple's iTunes Music Store.

Computer counters for unreserved
ticketing

Computer counters for unreserved
ticketing 07/19/2004 01:17 AM
NewIndPress Jul 19 2004 5:54AM GMT

NEC counters Nokia's Japanese attack

NEC counters Nokia's Japanese attack 06/18/2004 05:31 PM
CNET Asia Jun 18 2004 9:45PM GMT

Counting the Pages: DevArticles on
Counters

Counting the Pages: DevArticles on
Counters 09/19/2002 07:43 AM

Hotmail counters Google e-mail

Hotmail counters Google e-mail 06/24/2004 06:15 AM
The battle for e-mail subscribers hots up, with Microsoft upping the amount of storage for Hotmail users.

Yahoo counters Google with own e-mail
offer

Yahoo counters Google with own e-mail
offer 06/15/2004 06:23 PM
International Herald Tribune,France-1 hour agoYahoo will substantially increase the amount of free storage it gives its e-mail customers in an effort to respond to Google's incursion into e-mail services. ...

Google Tests Click Through Counters on
All Listings

Google Tests Click Through Counters on
All Listings 11/06/2002 04:23 AM
All listings currently have click through counters on them.

Study counters Internet, risky sex link

Study counters Internet, risky sex link 12/31/2003 07:20 PM
Gay.com Dec 31 2003 5:33PM ET

Everyone Punt on The Search Engine
Conversion Counters?

Everyone Punt on The Search Engine
Conversion Counters? 10/28/2003 11:08 PM

Google counters suit over search
rankings

Google counters suit over search
rankings 01/13/2003 03:02 PM
IN A CASE that underscores the increasing importance search rankings have on business, Google Technologies is fighting to dismiss a lawsuit claiming that it ...

AMD's Pacifica Technology Counters
Intel's Silvervale

AMD's Pacifica Technology Counters
Intel's Silvervale 09/12/2004 08:12 PM
AMD Zone Sep 12 2004 11:34PM GMT

Google counters suit over lowered search
rankings

Google counters suit over lowered search
rankings 01/14/2003 02:16 AM
By Scarlet Pruitt. BOSTON - In a case that underscores the increasing importance search rankings have on business, Google Technologies Inc. ...

Yahoo counters Google's e-mail offer
with more online storage

Yahoo counters Google's e-mail offer
with more online storage 06/15/2004 02:57 PM
IHT Jun 15 2004 6:36PM GMT
Grok Description matches for Most useful counters for SQL Server performance monitoring
GrokA matches for Most useful counters for SQL Server performance monitoring

ByteMonsoon - BitTorrent Tracker

ByteMonsoon - BitTorrent Tracker 05/06/2004 05:43 PM
ByteMonsoon v2.0.5 Released

PR: Zend Brings Performance Management
to PHP With New Zend Performance Suite

PR: Zend Brings Performance Management
to PHP With New Zend Performance Suite 11/03/2002 08:19 AM
Product Enables PHP-enabled Enterprises To Achieve Dramatic Server Performance Improvement and Decrease Total Cost of Ownership

Performance PCs

Performance PCs 12/31/2004 02:03 AM
PC Authority Dec 31 2004 6:44AM GMT

64-bit vs 32-bit AMD Performance

64-bit vs 32-bit AMD Performance 04/28/2004 05:52 AM

Naming for Performance

Naming for Performance 01/16/2004 01:02 PM

One of the not often discussed cause of slow performance is careless naming.

When you are naming a method that does more than get or set some value, try to avoid a name that might mislead the caller into calling it multiple times instead of saving it to a local variable.  For example, if a method is named GetTopicName, the caller is not going to expect it to search for the value and instantiate many objects in the course of doing so.  Instead use a name that implies and warns the caller about the cost of the method, like FindTopicName or CalcPrime.

When using a language that supports properties like C#, try not to turn heavy methods into properties.  Property getters and setters should be light operations.  If you have to, then try to precalculate the value and update on change via event handlers.  Failing that, try to warn the developer using documentation so the developer can use the property accordingly.

One caveat: Guidelines are not meant to be straightjackets.  Don't do it if you can't do it.

Flex Performance Brief

Flex Performance Brief 05/31/2004 03:36 PM
Compare the numbers for benchmark tests between a JSP and MXML application.

POWER5 Performance Brief

POWER5 Performance Brief 08/02/2004 03:46 PM

Pagefile Performance

Pagefile Performance 09/13/2004 06:03 PM

Other News: Mac OS X Performance

Other News: Mac OS X Performance 06/04/2004 10:56 AM
Kernelthread analyzes 10 Mac OS X performance optimizations.

Dancing performance

Dancing performance 04/27/2004 03:54 PM
I got a dance mat for my PS2 as a birthday present. So far, I've nearly twisted my ankle, and banged my head against the lamp.

But it's actually loads of fun: you get to feel again like a complete klutz when you can't do even simple transfers of your bodily weight. Kinda like when I first started martial arts. You also feel completely stupid because you can't recover from a simple mistake after missing rhythm. And also, you sweat like a pig after 30 minutes on it. Though frankly, I don't know whether pigs really sweat that much.

And in fact, the whole thing has rather little to do with dancing. Perhaps, with more practice, it might be possible to develop a knack for "improvisation in a confined space", but so far it feels more like an exercise routine. A pre-programmed performance, so to say.

But I ain't complaining. I can't dance (any teachers around?), but this sure is quite fun ;)

Web Performance Trainer 2.6 FCS

Web Performance Trainer 2.6 FCS 11/06/2003 07:21 PM
A load testing and stress testing tool for Web servers.

PHP Performance Profiling

PHP Performance Profiling 10/28/2003 11:08 PM
Techniques for learning where the bottlenecks are in your PHP-based Web application.

PHP Performance Profiling with APD

PHP Performance Profiling with APD 10/29/2003 12:11 AM
Good article on profiling PHP using APD, the Advanced PHP Debugger. This is a bit of a misnomer, because APD is not a debugger you use to step through your code, but is actually a diagnostic and profiling tool. I mostly use XDebug for profiling, but APD looks like a cool alternative.

And if you are interested in performance tuning, do have a look at ADOdb's database performance monitoring features. The dreadful thing about SQL is that it is an iceberg of complexity hidden in a deceptively simple query language. Bad PHP code can slow your code down by a factor of x2-5 perhaps. But one bad SQL statement can cause a x10-100 times slowdown.

Lastly, if you are using Windows, unless you have the ability and means to compile APD, you're out of luck. This is one area where PECL (which is the official repository for PHP extensions) could improve on.

Update: George (APD's author) mentions that Shane Caraveo has ported APD to Windows, and Will and John add that pre-compiled PECL dll's for Windows are available from here and there. (added 25 Oct 2003).

Seeing Hutton's last performance

Seeing Hutton's last performance 01/28/2004 12:29 PM
BBC News Online's Brian Wheeler was in Court 73 to witness Lord Hutton's statement.

New performance targets for NHS

New performance targets for NHS 02/10/2004 09:00 AM
New NHS performance targets emphasising quality of patient care are to be introduced from April 2005.

The Performance Paradox

The Performance Paradox 04/11/2005 06:11 AM
If you deliver, you only qualify to deliver more. So how can we possibly get off the treadmill?

Battlefield 2 - GPU Performance

Battlefield 2 - GPU Performance 06/17/2005 03:45 PM

Q&A: Performance + Art from Microsoft

Q&A: Performance + Art from Microsoft 07/08/2004 03:37 PM
Today marks the debut of a collection of trendsetting new input devices from Microsoft, including a new mouse conceived by Philippe Starck - an interior and industrial designer and architect known worldwide for bringing cutting-edge design to everyday products. Starck's award-winning work centers around a core philosophy focused on delivering extraordinary design in everyday objects. This vision has changed the way people perceive their juicer, hotel room, toothbrush, chair and even tape dispenser.

Performance Anxiety

Performance Anxiety 06/17/2005 03:56 PM
Link: Seed of extinct date palm sprouts after 2,000 years. The Judean date is chronicled in the Bible, Quran and ancient literature for its diverse powers -- from an aphrodisiac to a contraceptive -- and as a cure for a...

Eclipse performance.

Eclipse performance. 03/12/2003 10:29 AM

eclipse.exe -vmargs -Xverify:none -XX:+UseParallelGC -XX:PermSize=20M 

 -XX:MaxNewSize=32M -XX:NewSize=32M -Xmx96m -Xms96m

Sosume applies some new GC configuration settings, written about in JavaWorld and recommended for Netbeans to improve Eclipse performance in his post: Improving Eclipse performance by using vm arguments. I'm trying these settings myself now, but with -Xmx256m.

Getting ASP.NET Performance Data

Getting ASP.NET Performance Data 09/09/2004 06:02 PM

FreeRoller performance.

FreeRoller performance. 03/11/2003 09:43 AM

As FreeRoller users and readers know, FreeRoller is having problems keeping up with the load of 500+ weblogs and the 101-list traffic. Sometimes the main page takes several minutes to load and often the system just collapses under the stress. According to Anthony Eden, who runs FreeRoller, the system is powered by one little eMachines box. I could use that as an excuse, but, regardless of the hardware, the poor performance of FreeRoller reflects poorly on the Roller software.

I considered using a profiler to figure out the root cause of the performance problem, but a profiler is difficult to setup for a Servlet app, there's a learning curve, and there are only so many Roller hours in my weekend. Plus, I had a gut feeling that the Roller main page, index.jsp, was causing the slow-downs.

Looking at the code behind index.jsp, I found that it uses several queries to build a list of weblogs, hit counts, and the last update time for each weblog. The queries are not complex, but because they are executed using an Object-Relational (O/R) persistence framework (Castor) each query results in the creation of one object per row returned. FreeRoller has over 500 weblogs, so each refresh of the index.jsp page results in the creation of thousands of objects. Even with page caching in place to reduce the frequency of refreshes, this has the potential to bog down the whole system.

I rewrote the code behind index.jsp to use only one query and I also added a limit to that query so that a Roller administrator can limit the number of weblogs displayed on the main page. Next, I did some load testing with JMeter. I set up a JMeter test plan to use 3 threads to hit index.jsp, a 20-second ramp up, and a 300 ms delay between requests. I did this testing on a 1.5Ghz Athlon, 768MB RAM box running Windows XP, Java 1.4.1, and Tomcat 4.1.18. Here are the results:

                   Avg.  Dev.  Throughput  Note

1) Old index.jsp 1051ms  8629  120/min     Heavy CPU usage
2) New index.jsp  248ms  1326  248/min     Limit 500 weblogs
3) New index.jsp   93ms   186  247/min     Limit 30 weblogs
4) TC index.jsp    90ms    72  337/min     Tomcat example page

The old index.jsp would peg the CPU at 100% for minutes at a time during cache refreshes. I'm not sure why, but I suspect that multiple requests were simultaneously refreshing the cache (I'm not sure how OSCache hanldles this). During test #1, Roller was so slow as to be almost unusable. Test #2 and #3 show that the new index.jsp is a great improvement. With a limit of 500 weblogs, the CPU usage is very heavy during a cache refresh but doesn't get to 100%. With a limit of 30 weblogs, the cache refresh does not have a noticable effect on the CPU. Test #4 tests the Tomcat examples page, it is included only as a baseline for comparison.

I made the above changes in the Roller 0.9.6 code branch so that they can me applied to FreeRolller right away. I'm still not happy about Roller performance and memory usage. I'm sure there is plenty of room for improvement. My next experiment is implementing the Roller business tier with the Hibernate O/R framework. I'm curious to see how it compares to Castor.

Getting Disk Performance

Getting Disk Performance 09/23/2004 05:52 PM

Performance Co-Pilot 2.4.0-1

Performance Co-Pilot 2.4.0-1 08/12/2004 11:43 PM
performance monitoring toolkit and API

IBM Buys into Performance Management

IBM Buys into Performance Management 07/29/2004 01:34 PM
The vendor nabs Cyanea in a bid to boost its software lines with application performance management.

Doom 3 Performance: Part 1

Doom 3 Performance: Part 1 08/02/2004 10:25 AM

Mega GPU Performance Comparison

Mega GPU Performance Comparison 07/28/2004 11:38 AM

Rambus in Your Performance PC 's Future?

Rambus in Your Performance PC 's Future? 02/13/2004 02:30 PM
At this year's IDF, Rambus is touting its new XDR DRAM tech, which promises ultra high memory subsystem bandwidth. If all goes well, it might be the top high-performance PC main memory architecture by 2006.

Package Compression Performance

Package Compression Performance 08/08/2004 12:17 AM

Viacom's Dazzling Performance

Viacom's Dazzling Performance 07/22/2004 02:41 PM
Couch potatoes watch more ads as the firm grows its cash pile.

Most useful counters for SQL Server performance monitoring

The following phrases have been identified by the grok system as matching this entry: bytemonsoon performance