Slow Problems

Ok.  I have an IIS webpage that goes back to SQL server 2k (sp4) . All of
the employees use that program for all their daily activities.  Here is the
problem.  The server has completely dies and I had to rebuild from scratch.
It used to be on 2k server and I now I installed it on 2003 server.  Now all
the users are complaining that the software is much slower.
I'm not a big SQL expert, so can anyone help me troubleshoot this?  I'm
assuming that Query times for each link have increased, but have no idea why
or how to fix.

Thank You!

Have you tried updating the statistics?  sp_updatestats

--
Andrew J. Kelly  SQL MVP


"Kory" <koryg@community.nospam> wrote in message
 news:%2344%232xf8FHA
.3592@TK2MSFTNGP12.phx.gbl...
> Ok.  I have an IIS webpage that goes back to SQL server 2k (sp4) . All of
> the employees use that program for all their daily activities.  Here is
> the problem.  The server has completely dies and I had to rebuild from
> scratch. It used to be on 2k server and I now I installed it on 2003
> server.  Now all the users are complaining that the software is much
> slower.
> I'm not a big SQL expert, so can anyone help me troubleshoot this?  I'm
> assuming that Query times for each link have increased, but have no idea
> why or how to fix.
>
> Thank You!
>

I don't understand.  What does that do?  I really don't know much about SQL.
Please let me know how this works.

Thank You!



"Andrew J. Kelly" < sqlmvpnooospam@shadh
awk.com> wrote in message
news:u7TAxzg8FHA.3544@TK2MSFTNGP09.phx.gbl...
> Have you tried updating the statistics?  sp_updatestats
>
> --
> Andrew J. Kelly  SQL MVP
>
>
> "Kory" <koryg@community.nospam> wrote in message
>  news:%2344%232xf8FHA
.3592@TK2MSFTNGP12.phx.gbl... 
>
>

Kory (koryg@community.nospam)  writes:
> Ok.  I have an IIS webpage that goes back to SQL server 2k (sp4) . All of
> the employees use that program for all their daily activities.  Here is
> the problem.  The server has completely dies and I had to rebuild from
> scratch. It used to be on 2k server and I now I installed it on 2003
> server.  Now all the users are complaining that the software is much
> slower. I'm not a big SQL expert, so can anyone help me troubleshoot
> this?  I'm assuming that Query times for each link have increased, but
> have no idea why or how to fix.

Unfortunately, this is a very open-ended question, as we know very little
about your system. Rather than making quizzes through the newsgroup, it
may be cheaper in the end to open a case with Microsoft to sort it out.
That will come with an invoice, but if the application is crawling, your
organisation may lose money because of that.

How did you migrate the SQL Server installation from the ole machine to
the new?

How did you transfer the databases from the old server?

Can you be more specific what is slow? Are particular operations slow?
Is connection slow? Once you have connected, do queries run fast in
general?

How much memory does the server have?

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

There is a help file that comes with SQL Server called BooksOnLine. I
suggest you look up that command and see if that helps.

--
Andrew J. Kelly  SQL MVP


"Kory" <koryg@community.nospam> wrote in message
news:uNgu1nr8FHA.2364@TK2MSFTNGP12.phx.gbl...
>I don't understand.  What does that do?  I really don't know much about
>SQL. Please let me know how this works.
>
> Thank You!
>
>
>
> "Andrew J. Kelly" < sqlmvpnooospam@shadh
awk.com> wrote in message
> news:u7TAxzg8FHA.3544@TK2MSFTNGP09.phx.gbl... 
>
>

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.

Thank You

"Andrew J. Kelly" < sqlmvpnooospam@shadh
awk.com> wrote in message
news:ebbZR$08FHA.3044@TK2MSFTNGP10.phx.gbl...
> There is a help file that comes with SQL Server called BooksOnLine. I
> suggest you look up that command and see if that helps.
>
> --
> Andrew J. Kelly  SQL MVP
>
>
> "Kory" <koryg@community.nospam> wrote in message
> news:uNgu1nr8FHA.2364@TK2MSFTNGP12.phx.gbl... 
>
>

When I say slow, I mean that when you click on any link in the 3rd party
program, it takes twice as long to retrieve the page as it used to.  I think
its becuase SQL Queries take longer.
The way the DB was installed, I just copied the DB files from original
server and attached them here.  Nothing else.

Thanks.


"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
 news:Xns971B59BE4DAD
Yazorman@127.0.0.1...
> Kory (koryg@community.nospam) writes: 
>
> Unfortunately, this is a very open-ended question, as we know very little
> about your system. Rather than making quizzes through the newsgroup, it
> may be cheaper in the end to open a case with Microsoft to sort it out.
> That will come with an invoice, but if the application is crawling, your
> organisation may lose money because of that.
>
> How did you migrate the SQL Server installation from the ole machine to
> the new?
>
> How did you transfer the databases from the old server?
>
> Can you be more specific what is slow? Are particular operations slow?
> Is connection slow? Once you have connected, do queries run fast in
> general?
>
> How much memory does the server have?
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx

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

Kory  wrote:
> When I say slow, I mean that when you click on any link in the 3rd
> party program, it takes twice as long to retrieve the page as it used
> to.  I think its becuase SQL Queries take longer.
> The way the DB was installed, I just copied the DB files from original
> server and attached them here.  Nothing else.

Chances are that your current configuration of the database does not match
the old one.  Maybe you have slower disks or configured less memory for
SQL Server.  Impossible to tell from here...

Kind regards

robert

So what should I do to narrow it down?




"Robert Klemme" <bob.news@gmx.net> wrote in message
news:OlC8akD9FHA.2616@TK2MSFTNGP15.phx.gbl...
> Kory wrote: 
>
> Chances are that your current configuration of the database does not match
> the old one.  Maybe you have slower disks or configured less memory for
> SQL Server.  Impossible to tell from here...
>
> Kind regards
>
>    robert
>