December 17, 2009 at 5:46 pm
Hello,
There i a performance problem. the scripts are running very slow. The stats are not out dated. database space is ok. I checked the MDF disk space and its 39 GB free space out of 399 GB. Do you think if we increasing the disk space will improve the performance. I ran the execution plan and that looks fine as well. There is 0-10% cost. We even added the missing indexes. Please suggest. My manager is asking how increase in disk space will impact performance?
December 17, 2009 at 8:01 pm
Increasing disk space is not the issue you need to address. First address what is the reason the performance is slow? Are all queries slow or a particular one is significantly slow? Post the Query execution plan, of the query you are dealing with (If trying to tune one query).
There are many things to look at, have you seen any locking and blocking occuring? Has the system become slow gradually or is it slow at times?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 18, 2009 at 2:21 am
What are the operations you are performing in the scripts?????
December 18, 2009 at 5:44 am
hydbadrose (12/17/2009)
Hello,There i a performance problem. the scripts are running very slow. The stats are not out dated. database space is ok. I checked the MDF disk space and its 39 GB free space out of 399 GB. Do you think if we increasing the disk space will improve the performance. I ran the execution plan and that looks fine as well. There is 0-10% cost. We even added the missing indexes. Please suggest. My manager is asking how increase in disk space will impact performance?
Hi,
Please read the Jeff & Gail article's added in my signature.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
December 18, 2009 at 7:31 am
Unless you're in a situation where your database is consistently too small and the auto-grow is set too low, space is seldom the cause of performance issues.
You said you looked at the execution plan, but you just listed estimated costs. That doesn't tell you much. What operations were associated with these costs? Table Scans, Index Scans, Order operations in support of merge joins, hash joins, work tables? There are so many issues that could be causing the problem and you need to carefully read the execution plan to understand what it's telling you.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 18, 2009 at 8:27 am
Check if the query in the script is optimized or not. Try doing a plan on it.
Add / drop idx as required to boost the perf. see if this helps
Also what is within the script? has it been slow once in a while? give more details...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply