Ask Your Computer Question. Computer Experts Answer You ASAP.

(Not a Computer Question?)

SQL Server Database

Sent to Computer Experts April 2 2005 at 9:49 AM
   

What is the best strategy for monitoring the performance of a SQL Server 2000 installation? What hardware components are involved in successful monitoring of a database installation? What can be done within the database itself to increase performance?

Customer (name blocked for privacy)
Status:  Closed   Value: $10
Answer
April 5 2005 at 6:09 AM (2 days and 20 hours later)
         
ACCEPTEDCheck Mark
What can be done within the database itself to increase performance?

Depends on what your database does but as a general rule here are some things I would look for as well as links to information you might find useful.

Create Indexes based on what query optimizer tells you.

http://www.sql-server-performance.com/optimizing_indexes.asp




What is the best strategy for monitoring the performance of a SQL Server 2000 installation?

http://www.sql-server-performance.com/tp_centralized_sql_server_monitoring.asp

William Foster -- Sr Systems Engineer -- 100% Positive Feedback on 39 Computer Accepts
14+ years professional experience in Windows/ Linux MCSE Microsoft Certified since 1996
Think you can answer this question?
Login or Become an Expert

Related Answers

 

DISCLAIMER: You acknowledge that any information you may obtain from individuals you contact through use of the JustAnswer service comes from those individuals, not from JustAnswer, and that JustAnswer is not in any way responsible for any of the information these third parties may supply. The site and services are provided "as is" with no warranty and no representations are made regarding the qualification of an Expert. Responses and comments on JustAnswer are for general information and are not intended to substitute for informed professional advice (such as medical, legal, investment or accounting) and do not establish a professional-client relationship. JustAnswer is not intended or designed to address EMERGENCY QUESTIONS which should be directed immediately by telephone or in-person to qualified professionals. Please carefully read the Terms of Service.

JustAnswer > Computer Questions