Slow Problems

#1

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!

#2

Have you tried updating the statistics? sp_updatestats

--
Andrew J. Kelly SQL MVP

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

Quote:

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!

#3

Kory (koryg (AT) community (DOT) nospam) writes:

Quote:

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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#4

Hi Kory,

As MVP Erland and MVP Andrew said, this is a fairly open question for
performance issue.

I understood you scenario as below
- You have migrated Windows 2000 to Windows Server 2003
- You are using SQL Server 2000 SP4 as backend for your application
- Result of the query returns slower than before.

If I have misunderstood your concern, please feel free to point it out.

Based on my knowledge, if you have made sure statistics was updated by
sp_updatestats, you should using Profiler / Performance Monitor to check
what's the bottleneck for your system. Here are some valueable links for
your reference.

sp_updatestats
http://msdn.microsoft.com/library/de...us/tsqlref/ts_
sp_ua-uz_14kz.asp

HOW TO: Troubleshoot Application Performance Issues
http://support.microsoft.com/kb/298475/

TechNet Support WebCast:Performance troubleshooting and analysis in
Microsoft SQL Server 2000
http://support.microsoft.com/kb/838622

Support WebCast: How to Collect and Analyze Performance Data in Microsoft
SQL Server
http://support.microsoft.com/kb/324692

HOW TO: Troubleshoot Application Performance with SQL Server
http://support.microsoft.com/kb/224587

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

#5

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 (AT) sommarskog (DOT) se> wrote

Quote:

Kory (koryg (AT) community (DOT) 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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#6

Kory wrote:

Quote:

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

#7

Kory wrote:

Quote:

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

#8

So what should I do to narrow it down?

"Robert Klemme" <bob.news (AT) gmx (DOT) net> wrote

Quote:

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

#9

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

Quote:

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

#10

On Mon, 28 Nov 2005 17:26:32 -0500, "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?

Most databases run with auto-stats on, so it should (SHOULD!) take
care of itself from now on. Look up auto-stats in BOL to see how to
check it. See how much you're learning, fun, huh?!?

Josh