Discussion Locked

Stored Procedures Performance

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am using SQL Server 2000. And i wrote some SP. I need to run this stored procedure on 2.2 million data, and it again creats 7.8 million data. Its taking so much time to do this. I want to know some tips to improve the SQL Server performance and some tips regarding the Stored Procedures. Please let me know. Thank you.

6 replies

by timthetoolman

Hi,

Without knowing what your query is or the structure of your database, I cant really give you specifics... but here is a site that describes tuning a SQLServer2000 database.

It will have useful information for your SP writing too!

Hope it helps,
Cheers,
Tim.

This discussion is closed to new replies.