General discussion

Locked

Stored Procedures Performance

By sharathchandra ·
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.

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Stored Procedures Performance

by TimTheToolMan In reply to Stored Procedures Perform ...

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.

Collapse -

Stored Procedures Performance

by TimTheToolMan In reply to Stored Procedures Perform ...

...and here is the link...

http://www.sql-server-performance.com/

D'oh.

Cheers,
Tim.

Collapse -

Stored Procedures Performance

by sharathchandra In reply to Stored Procedures Perform ...

The question was auto-closed by TechRepublic

Collapse -

Stored Procedures Performance

by sharathchandra In reply to Stored Procedures Perform ...

The question was auto-closed by TechRepublic

Collapse -

Stored Procedures Performance

by sharathchandra In reply to Stored Procedures Perform ...

This question was auto closed due to inactivity

Back to Web Development Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums