[dba-SQLServer] My database is slow

Hi John,

So it is SQL Server itself or the billing db?

Are other db's also slow?  If it is just billing then you need to look at
indexes etc, and as Bobby is suggesting, you may want to use the wizard to
create a daily maintenance plan, that will re-build the indexes on specified
databases. I always include a daily maintenance plan on any transaction
based db's I look after.

However, if it is machine and OS / installation related, that is all
irrelevant and you need to look at firewall, AV or some other machine
related issue.  I would plum first for a careful complete removal of SQL and
another install in that case.  I would turn off AV/ Firewal and anything
else that might effect it (Spyware software).

Let us know which it is, I recently upgraded a few machines to sql 2008 and
would be keen to hear how you get on.

Also, is it slow in SSMS or just through the GUI that you are using?  IOW,
could it be ABO or ODBC related?

Mark

On 22 March 2010 01:29, jwcolby <jwcolby at colbyconsulting.com> wrote:

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