Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft SQL Server > Re: slow querie...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 13 Topic 11198 of 11431
Post > Topic >>

Re: slow queries for a particular database

by Marc Baker <mbaker@[EMAIL PROTECTED] > Jun 30, 2008 at 02:35 PM

On Jun 30, 4:37=A0pm, "Plamen Ratchev" <Pla...@[EMAIL PROTECTED]
> wrote:
> Outdated statistics can cause such performance issues. Update the
statist=
ics
> and see if that
helps:http://msdn.microsoft.com/en-us/library/ms187348.as=
pxhttp://msdn.microsoft.com/en-us/library/ms173804.aspxhttp://www.sql-serve=
r-performance.com/tips/update_statistics_p1.aspx
>
> HTH,
>
> Plamen Ratchevhttp://www.SQLStudio.com

There was a maintenance plan to update the statistics already for this
db.  I deleted, and reset it up, and executed manually.  Completed
successfully in approx. 7 mins., but a count is still taking an
extremely long time.
 




 13 Posts in Topic:
slow queries for a particular database
Marc Baker <mbaker@[EM  2008-06-30 12:59:05 
Re: slow queries for a particular database
"Plamen Ratchev"  2008-06-30 16:37:20 
Re: slow queries for a particular database
Marc Baker <mbaker@[EM  2008-06-30 14:35:52 
Re: slow queries for a particular database
"Plamen Ratchev"  2008-06-30 17:58:18 
Re: slow queries for a particular database
Erland Sommarskog <esq  2008-06-30 22:05:42 
Re: slow queries for a particular database
Marc Baker <mbaker@[EM  2008-07-01 07:49:26 
Re: slow queries for a particular database
Erland Sommarskog <esq  2008-07-01 21:48:16 
Re: slow queries for a particular database
Gert-Jan Strik <sorry@  2008-07-02 22:20:11 
Re: slow queries for a particular database
Marc Baker <mbaker@[EM  2008-07-01 20:38:12 
Re: slow queries for a particular database
Erland Sommarskog <esq  2008-07-02 21:30:31 
Re: slow queries for a particular database
Marc Baker <mbaker@[EM  2008-07-02 15:05:06 
Re: slow queries for a particular database
Sybaseguru <collap@[EM  2008-07-03 14:25:52 
Re: slow queries for a particular database
Erland Sommarskog <esq  2008-07-03 21:46:24 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Oct 15 13:31:42 CDT 2008.