Guys emergency (database usage is more than 90 %)

Question

Guys emergency (database usage is more than 90 %)

ak08

Mr or Mrs. 500

Points: 543
More actions
May 31, 2012 at 9:37 pm

#256923

h

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

vinu512 SSCoach Points: 15729 More actions · Answer 1

Please be a little more elaborate about it. What does your application do?....What kind of queries/procedures/functions are you executing from the Front End?

Vinu Vijayan

For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Add more disk space and tune your queries. If you want more detailed answers, please provide a lot more detail on what's wrong.

For performance problems please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/ or if you're completely unfamiliar with performance tuning see these

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass