[dba-SQLServer] My database is slow

I had been running a query during development against a local db (SQL 2008
dev edition).  Then, out of the blue, my few minute query started taking
about 20 something minutes.  I then looked at the estimated and actual
execution plans and both of them showed 1 estimated records when where
should have been about 70 something thousand.  After talking with our DBA,
he suggested updating the statistics.  After updating the statistics on the
affected tables, the query was down to about 24 seconds.

I don't know if it might be the same issue with you, but maybe if you
checked your execution plans?

Bobby

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Sunday, March 21, 2010 9:30 PM
To: Discussion concerning MS SQL Server
Subject: Re: [dba-SQLServer] My database is slow

Uhh.... never.

8(

John W. Colby
www.ColbyConsulting.com


Bobby Heid wrote:
> John,
> 
> Have you updated statistics lately?
> 
> Bobby
> 
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Mark
Breen
> Sent: Saturday, March 20, 2010 8:34 AM
> To: Discussion concerning MS SQL Server
> Subject: Re: [dba-SQLServer] My database is slow
> 
> Hi John,
> 
> Is it the db or is it the db server?  You could detach your monster db's
and
> then you have just a plain ol' box with a couple of 1-2 mb db's attached,
>  you can then play with a test be with on table and see if that is slow.
> 
> To full eliminate the monsters, detach, reboot and review and then you
know
> it is either a) related to the monsters or b) box related and your large
> db's are irrelevant to solving this issue.
> 
> Sorry this is two days later,
> 
> Mark
> 
> 
> On 18 March 2010 17:06, jwcolby <jwcolby at colbyconsulting.com> wrote:
> 
>> Nope.  In fact I went in to see what is there for indexes and PKs and it
>> appears that the upsizing
>> wizard I ran ages ago created all of that stuff for me.  I never looked
at
>> it before but it's there.
>>
>> John W. Colby
>> www.ColbyConsulting.com
>>
>>
>> Myke Myers wrote:
>>> See if it lost your primary keys and indexes.
>>>
>>> Myke
>>>
>>> -----Original Message-----
>>> From: dba-sqlserver-bounces at databaseadvisors.com
>>> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby
>>> Sent: Thursday, March 18, 2010 12:42 PM
>>> To: Sqlserver-Dba
>>> Subject: [dba-SQLServer] My database is slow
>>>
>>> I had a SQL Server 2005 (I think) database, running in SQL Express.  It
>> was
>>> "fine", no obvious slowdown.
>>>
>>> I wanted to be able to access 2008 databases and was unable to do so
>> using
>>> Management studio 2005 which I had installed.  I tried to "upgrade" but
>> 2008
>>> just refused to cooperate.  I ended up uninstalling all of Express as
>> well
>>> as all of 2005 whereupon 2008 decided to cooperate and installed just
>> fine.
>>> Now my billing database is abysmally slow.  As in 20 seconds to open any
>>> table.  Sometimes.
>>> Sometimes not.  Buy just loading the combos that used to open instantly
>> is
>>> now taking literally 20 seconds.
>>>
>>> This is unusable, and I don't know where to start in figuring out why.
>>>
>>> Any ideas where to start?  In DETAIL (I am not a DBA).
>>>
>>> --
>>> John W. Colby
>>> www.ColbyConsulting.com