Home > IT Answers > Storage > High Disk usage on SQL Server 2005
Jsql
155 pts.
 High Disk usage on SQL Server 2005
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
ASKED: August 17, 2010  8:58 AM
UPDATED: August 31, 2010  5:51 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  August 18, 2010  6:43 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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.

Jsql
 155 pts.
 

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?

Denny Cherry
 64,550 pts.