Hi Everybody,
I have installed Sql-server-2000 on windows-2000 based-
server, i have a trouble with a table, it has 5.5 millions
of records and sql'sever's procedure runs very slow when i
run a query or a Store procedure. I have installed
servicepack 3 for sql-server-2000. Any help please..

You don't give us much to use to help you.

What type of machine are you running on? A PII 300 with 128MB of RAM and a single IDE HD, or a P4 2Ghz quad Xeon machine with 2GB of RAM and a good SCSI disk array with a quality disk controller?

What type of query are you doing? If you return all rows (SELECT * FROM table) then yes, things will be slow. I would even guess that your client will run out of memory.

If you are trying to retrieve a few rows, do you have proper indexes in place on the table?

--
Keith, SQL Server MVP

"FEVIS" <fermin_bueno (AT) hotmail (DOT) com> wrote