|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > Poor Performance on SQL 2000 Stored Procedure Execution
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Poor Performance on SQL 2000 Stored Procedure Execution
|
|
| Mike Chen 2002-10-05, 9:07 pm |
| Hi,
This stored procedure used to be able to execute in 6.5
within 10 minutes. Since I have loaded 2000 on my
machine, it takes more than 300 minutes to finish the
execution. The number of records in my database is more
than 150,000. Once I reduced the records to 50,000, it
runs fine, but in 6.5 I didn't have to reduce the records,
it ran fine. Do you know what's wrong?
| |
| Dinesh.T.K. 2002-10-05, 9:07 pm |
| Mike,
Try updating the statistics.
Dinesh
--
--
SQL Server FAQ at
www.tkdinesh.com
"Mike Chen" <wchen@drc.com> wrote in message
news:1083501c259d3$269e5f40$3b
ef2ecf@TKMSFTNGXA10...
> Hi,
> This stored procedure used to be able to execute in 6.5
> within 10 minutes. Since I have loaded 2000 on my
> machine, it takes more than 300 minutes to finish the
> execution. The number of records in my database is more
> than 150,000. Once I reduced the records to 50,000, it
> runs fine, but in 6.5 I didn't have to reduce the records,
> it ran fine. Do you know what's wrong?
>
|
|
|
|
|