Database performance monitoring Get Started
Bring yourself up to speed with our introductory content
Ensure your customer's SQL Server 2008 R2 environment has the proper resources by determining workload group requirements with Resource Governor and classifying server requests. Continue Reading
Evaluate Database performance monitoring Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
HP IO Accelerator cards let Answers.com implement solid-state storage for database performance boost
To improve database performance on its Web servers, Answers.com implements solid-state storage using HP IO Accelerator cards; sees a 900% increase in the number of queries each database server can handle. Continue Reading
Manage Database performance monitoring
Learn to apply best practices and optimize your operations.
Learn the difference between static SQL vs. dynamic SQL and the benefits and drawbacks of each for database application performance. Get a definition of stored procedure, find out about database drivers and wire protocol database drivers and how the network affects database performance. Continue Reading
Learn to use Performance Monitor counters in Windows to optimize domain controllers for maximum system and database performance. Continue Reading
Learn about SQL Server performance counters in this excerpt from 'SQL Server 2000 for experienced DBAs' by Brian Knight. Continue Reading
Problem Solve Database performance monitoring Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
Identifying and resolving bottlenecks is key to a high-performing SQL Server. Types of bottlenecks include memory, disk and CPU bottlenecks. SQL Server MVP Hilary Cotter explains how to locate these log jams using System Monitor, SQL Profiler and DMVs. Continue Reading
This chapter excerpt contains tips designed to achieve the greatest performance gain in your Oracle database with the least effort by focusing on the initialization parameters that yield the biggest impact. Continue Reading
I have a critical performance issue due to the large volume of data for a specific customer. Whenever customer XYZ's data is being fetched the query takes about half an hour to execute, whereas it fetches the data in seconds for the rest of the customers. Continue Reading