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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-25 : 13:12:24
|
BheemRaj writes "I have one asp project which uses STORED PROCEDURES heavily. It works fine on one SQL-Server 7.0 (www.net2e-biz.com --> NT based Server). Now we are moving to our own dedicated server and we have put all our code over there (copied all the stored procedure from earlier server to newer one). This server is also Win2000 based.
Now my problem is that same code(Stored Procedures) are working fine on one SQL-Server 7.0 but are very-very-very sluggish on second Sql-Server(window2000 based).
The errors comes on the line of command.Execute()
When i put command.CommandTimeout=0 , then stored procedure runs but it works very slow(6-10 minutes to execute on the site).
What i think is problem could be with the less amount of SQL resources.now please help me and tell me how to solve this problem.
If u need more details, then i am ready to give.
Please help." |
|
|
|
|
|
Same code but works different in different Sql Servers