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 |
|
california6
Starting Member
38 Posts |
 Posted - 2009-02-04 : 19:35:13
|
| I am monitoring long running queries on my SQL Server and this specific query is initiated by MSAS box. To complete, It takes 25-30 minutes on an average and i failed to understand as to what is it doing: DECLARE @OlapEvent BIGINT;SELECT @OlapEvent = ObjIdUpdate(2);SELECT (@OlapEvent & convert(bigint, 0xffff000000000000)) / 0x0001000000000000 AS Status, (@OlapEvent & convert(bigint, 0x0000ffff00000000)) / 0x0000000100000000 AS DbId, @OlapEvent & convert(bigint, 0xffffffff) AS ObjId;Can somebody please take a moment and suggest, what this query is doing and how can i reduce the execution time? Cali |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-03-03 : 09:17:54
|
I think it is the ObjIdUpdate function that takes time.Have Profiler to monitor you calls to determine how to proceed.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
Long running query