Home > Archive > MS SQL Server > March 2006 > Re: Isn't my SQL Server hardware sufficient for my server load? Why does it keep getting slow?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: Isn't my SQL Server hardware sufficient for my server load? Why does it keep getting slow?
puneet.agrawal@gmail.com

2006-03-28, 3:23 am

Hello all,

My problem has been solved. It was due to sql server generating wrong
statistics due to using a very small percentage of ttoal no. of rows
for sampling when i used sp_updatestats to update stats. It works
perfectly fine when I use dbcc reindex.

Thanks to everyone for the help.

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com