stored procedure response time(2)

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

stored procedure response time(2)

Author

Topic

mk_garg20
Constraint Violating Yak Guru

343 Posts

Posted - 2004-08-27 : 01:49:31

Hi all,
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=37442&SearchTerms=stored,procedure,response,time

This link shows my previous discussion with others on this topic.

One main problem is this table "CIMEL04.CDSYD.DBO.GL20000" in stored procedure.

This table is stored in DB at remote location. SP takes lot of time to get data from this time.

What can i do to improve this.

Thanks

mk_garg

hgorijal
Constraint Violating Yak Guru

277 Posts

Posted - 2004-08-27 : 02:52:03

Use column names a Kristed suggested.
Also, determine if this table can be replicated from the remote server to your local server. This will boost your performance very much.

Hemanth Gorijala
BI Architect / DBA

mk_garg20
Constraint Violating Yak Guru

343 Posts

Posted - 2004-08-27 : 02:54:23

I am following Kristen's suggestion. I will try copying data locally.

Thanks

mk_garg

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources