[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
> > _______________________________________________
> > 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
>
>