Slow Problems

#11

Kory wrote:

Quote:

So what should I do to narrow it down?

You can check the overall instance configuration (Enterprise Manager,
instance properties).

robert

#12

It is always good practice to update the stats after a restore. Other than
that the Auto Update usually does a good gob of keeping them up to date.

--
Andrew J. Kelly SQL MVP

"Kory" <koryg (AT) community (DOT) nospam> wrote

Quote:

Wow. I ran the sp_updatestats and everything works much better now. Can
you please tell me if this is regular maintance that I need to do every so
often or is it a one time thing that I had to do because I moved database
from another box with possibly different settings?

Thank You!

"Robert Klemme" <bob.news (AT) gmx (DOT) net> wrote in message
news:Og%23YbhD9FHA.4028 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
Kory wrote:
HI! I did look it up in BooksOnLine, the problem is that I still
don't know how to execute the command. Books online tells me how to
use the command, I just don't know how to get into the prompt that
will take those commands. I use SQL in GUI and have my application
connect to it.
Please help.

You can execute them with Query Analyzer.

robert

#13

Great. Thanks ALOT for all your help.

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Quote:

It is always good practice to update the stats after a restore. Other
than that the Auto Update usually does a good gob of keeping them up to
date.

--
Andrew J. Kelly SQL MVP

"Kory" <koryg (AT) community (DOT) nospam> wrote in message
news:OYpBZsG9FHA.2036 (AT) TK2MSFTNGP14 (DOT) phx.gbl...
Wow. I ran the sp_updatestats and everything works much better now. Can
you please tell me if this is regular maintance that I need to do every
so often or is it a one time thing that I had to do because I moved
database from another box with possibly different settings?

Thank You!

"Robert Klemme" <bob.news (AT) gmx (DOT) net> wrote in message
news:Og%23YbhD9FHA.4028 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
Kory wrote:
HI! I did look it up in BooksOnLine, the problem is that I still
don't know how to execute the command. Books online tells me how to
use the command, I just don't know how to get into the prompt that
will take those commands. I use SQL in GUI and have my application
connect to it.
Please help.

You can execute them with Query Analyzer.

robert

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Slow Problems

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup

Re: Slow Problems - 11-29-2005 , 02:25 AM

Re: Slow Problems - 11-29-2005 , 06:01 AM

Re: Slow Problems - 11-29-2005 , 08:11 AM