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 |
|
neellotus
Starting Member
15 Posts |
 Posted - 2012-09-01 : 00:57:16
|
| Dear All,I have created trace template to find slow running queries of SQL Server-2005.So i created trace with following events:-RPC:Completed, SP:StmtCompleted, SQL:BatchStarting, SQL:BatchCompleted, Showplan XMLI found statement named "Update ENVSET_1 Set CTLIDX = '33C49884-A1BF-4899-B2E3-29D45370D3EB' "in TextData Column under SQL:BatchCompleted Event Class.I am not understanding this statement and it is always taking execution time >2 Minutes.Please tell me what is the meaning of this statement i will be very thankfull 2 u.Thanx in advance.RegardsNeel |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-01 : 04:18:17
|
| its just setting CTLIDX field of table ENVSET_1 to a GUID value------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
What is Update ENVSET_1 Set CTLIDX = '33C49884-A1B