SQL Server 2000 Performance issue

Tags:
Management
Microsoft Windows
OS
Security
Servers
SQL
SQL Server
Hello! I am .Net developer.My client has more than 300 outlets for transaction sql server queries. When web application runs, SQL Server2000 occupies 100% CPU usage & uses 1.7GB memory usage. I am really confused how to minimize the CPU usage of SQL Server2000 as it slow down the performance of the web application. I really highly appriciate your cooperation for overcoming my problem Best regards; Rizwan

Answer Wiki

Thanks. We'll let you know when a new response is added.

I’m no DBA but it sounds like you need to fire up SQL trace and see what type or number of transactions are running and causing the delays. AS you probably know, databases are usually the weak link in any application for many reasons.

My 2c is the cause is usually improper design as relates to SQL query design, serialization of requests, indexes and use of stored procedures.

For example, if a really weak SQL query design resulted in full table scans against a 1 million+ row table, that’s going to murder performance. Use of indexes, summary tables (eg archive out old data, say 3+ months old to another table or DB) and good SQL will prevent that.

Again, I’m not a DBA nor do have I used these tools myself but I’ve read good reviews on them:

http://www.quest.com/sql_server/overview.aspx

http://www.red-gate.com/products/sql_tools_overview.htm?gclid=CPHf9ZinsIkCFTBcFQod_AK9Vg

There’s a whole lot more companies that make SQL tuning tools than just these two. Without knowing your experience level with SQL, I’d say you can try to plug away using SQL trace or perhaps demoing one of these tools may lead you to conclude they are worth the investment.

Throwing more hardware at the DB server is unlikely to give you much of a boost in performance IMO. I’ve been there and done that…

Good luck.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following