[dba-SQLServer] My database is slow

jwcolby jwcolby at colbyconsulting.com
Sun Mar 21 20:29:09 CDT 2010


This is actually running on my laptop.  It has been SQL Server Lite for a couple of years, running 
just fine.

John W. Colby
www.ColbyConsulting.com


Mark Breen wrote:
> 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
>>> _______________________________________________
>>> dba-SQLServer mailing list
>>> dba-SQLServer at databaseadvisors.com
>>> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>>> http://www.databaseadvisors.com
>>>
>>> _______________________________________________
>>> dba-SQLServer mailing list
>>> dba-SQLServer at databaseadvisors.com
>>> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>>> http://www.databaseadvisors.com
>>>
>>>
>> _______________________________________________
>> dba-SQLServer mailing list
>> dba-SQLServer at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>> http://www.databaseadvisors.com
>>
>>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 



More information about the dba-SQLServer mailing list