|
|
|
| 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!
| |
| Andrew J. Kelly 2005-11-25, 8:23 pm |
| 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...
>
>
| |
| Erland Sommarskog 2005-11-26, 8:24 pm |
| 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
| |
| Andrew J. Kelly 2005-11-27, 7:23 am |
| 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
| |
| Robert Klemme 2005-11-28, 11:23 am |
| 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
| |
| Robert Klemme 2005-11-28, 11:23 am |
| 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
>
| |
| Andrew J. Kelly 2005-11-28, 8:23 pm |
| You would use the tool called Query Analyzer. Open the tool, connect to the
proper database and then issue this command:
exec sp_updatestats
--
Andrew J. Kelly SQL MVP
"Kory" <koryg@community.nospam> wrote in message
news:OZaEouC9FHA.4028@TK2MSFTNGP10.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...
>
>
| |
|
| 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@gmx.net> wrote in message
news:Og%23YbhD9FHA.4028@TK2MSFTNGP10.phx.gbl...
> Kory wrote:
>
> You can execute them with Query Analyzer.
>
> robert
>
| |
| jxstern 2005-11-28, 8:23 pm |
| On Mon, 28 Nov 2005 17:26:32 -0500, "Kory" <koryg@community.nospam>
wrote:
>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
| |
| Robert Klemme 2005-11-29, 3:23 am |
| Kory wrote:
> So what should I do to narrow it down?
You can check the overall instance configuration (Enterprise Manager,
instance properties).
robert
| |
| Andrew J. Kelly 2005-11-29, 7:23 am |
| 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@community.nospam> wrote in message
news:OYpBZsG9FHA.2036@TK2MSFTNGP14.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@gmx.net> wrote in message
> news:Og%23YbhD9FHA.4028@TK2MSFTNGP10.phx.gbl...
>
>
| |
|
| Great. Thanks ALOT for all your help.
"Andrew J. Kelly" < sqlmvpnooospam@shadh
awk.com> wrote in message
news:%23cIMxyN9FHA.3660@TK2MSFTNGP09.phx.gbl...
> 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@community.nospam> wrote in message
> news:OYpBZsG9FHA.2036@TK2MSFTNGP14.phx.gbl...
>
>
|
|
|
|