High usage of SQL Server

210 pts.
Tags:
Data usage
SQL Server
The SQL Server usage becomes high....How do I reduce the usage of SQL Server? The system performance becomes slow.

Answer Wiki

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

Odds are you’ll need to look at index usage and find your missing indexes and create the ones that are missing.  A lot more information needs to be provided before we can recommend a specific solution.

Discuss This Question: 2  Replies

 
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
  • jailall101
    What are the specifications of your computer. How much memory and processor speed does your computer have. We need this info to know what your 'high usage' really is.
    735 pointsBadges:
    report
  • jinteik
    it depends on a lot on what is being run. when you mention slow is it performance? it also can be you need to retune the way that the DB is getting data and pass to you. so fill us with more information then we will be able to help you 
    18,085 pointsBadges:
    report

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