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 |
|
waterduck
Aged Yak Warrior
982 Posts |
 Posted - 2009-08-12 : 03:46:19
|
hi, today i faced this weird situation...i create a stored procedure, insert some data into table variable(4k row).sometime this sto-pro runs only for 1 seconds but sometime it runs around 12.15min...ps. all the parameter are passing same value
Hope can help...but advise to wait pros with confirmation... |
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2009-08-12 : 04:12:25
|
any thought?
Hope can help...but advise to wait pros with confirmation... |
 |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-08-12 : 04:14:18
|
quote:
Originally posted by waterduck
hi, today i faced this weird situation...i create a stored procedure, insert some data into table variable(4k row).sometime this sto-pro runs only for 1 seconds but sometime it runs around 12.15min...ps. all the parameter are passing same value
Hope can help...but advise to wait pros with confirmation...
Delay may be of server load, no of connections etcSenthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
|
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-08-12 : 04:20:40
|
| Check your server's memory usage too.If you use table variable it should be created in memory. 4k rows are create load on memory.Better you can use temp tables.Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
|
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2009-08-12 : 04:22:48
|
im the only person running the express...in ssms...i test my sto-pro partlt and all of it run in less than a second...>"<
Hope can help...but advise to wait pros with confirmation... |
|
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-08-12 : 04:25:33
|
| Is there any application running on the box??Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
|
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2009-08-12 : 04:31:23
|
you can say the server is dedicate to me only...anyway i changed the query to cross apply and it works fine again...
Hope can help...but advise to wait pros with confirmation... |
|
|
|
|
|
|
weird situation