High Disk usage on SQL Server 2005

155 pts.
Tags:
Disk usage
SQL Server 2005
SQL Server 2005 (32-bit)
SQL Server 2005 Database
SQL Server 3.5 Compact Edition
We recently upgraded our application from version 3.1 to 3.5. We had run the latest schema and other DB changes on the existing 3.1 Database. This is how we upgrade to higher versions.

Now the problem is, after the upgrade, the disk usage has gone very high. What are the possible reasons for high disk usage how to troubleshoot and fix this problem.

The same application was tested in QA environment and we didnt notice any high disk usage.

Please help.



Software/Hardware used:
SQL Server 2005

Answer Wiki

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

This all depends on what was done within the change script. It a lot of data was backed up that could explain it. Does your QA database have the same amount of data as your production database? You should really contact your software vendor and ask them. Anyone here will just be guessing where they can actually give you an answer as they know the database and the software.

Discuss This Question: 3  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
  • Jsql
    Thanks for your response. We had used the same production DB backup in QA environment. I dont suspect the application because we had analyzed all possible queries using profiler and didnt find any issue. I would like to know if there are any other reason for the high disk usage or any thing else is happening on the Production environment. Thanks.
    155 pointsBadges:
    report
  • Jsql
    [...] 7. Jsql and Mr. Denny are hard at work conversing and getting to the bottom of Jsql’s high disk usage on SQL Server 2005. [...]
    0 pointsBadges:
    report
  • Denny Cherry
    You'll need to look at the amount of space usage for each table and see which tables in the production database have more space being used than the QA database. Then you can dig into the settings for that table and see what is going on. How have you determined that there is more space in use in QA?
    66,290 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