Lynn, you saved my day 😛

OK, now I run the "update" separately ...

EXEC msdb.sys.sp_dbmmonitorupdate @database_name = 'Navision-SQL'

... and then I execute the "results" without the update:

EXEC msdb..sp_dbmmonitorresults

@database_name =...

Thanks for your reply. Yes, I have create a test scenario making sure there is some data; your queries give indeed some result.

Also when I just execute this ...

EXEC msdb..sp_dbmmonitorresults...

OK, I'll try that! Thanks for the advice!

We do a Full Scan - using the MP - every weekend (because we have plenty of time to do this); every day we just do a sp_updatestats (because we...

We already have a complete statistic update up running every day ...

Update:

So far my customer could not provide the QEP and currently I cannot logon to the system (holidays!).

But they ran the Index Rebuild on that table which seems to help...

Taken from SSMS script generator:

ALTER TABLE [dbo].[XYZ$Customer] ADD CONSTRAINT [XYZ$Customer$0] PRIMARY KEY CLUSTERED

(

[No_] ASC

)

WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE =...

PK and Clustered Index is on this field "No_" (varchar(20))

Dave Ballantyne (12/19/2012)

---

The writes could be due to a memory spill

http://www.sqlpassion.at/blog/PermaLink,guid,2a24830a-5cf9-4438-96e9-af0a6d7372c3.aspx

In terms of what else *could* (pure guesswork 🙂 ) be happening here:

The "delay" may not even be in...

First, identify if that's the actual performance bottleneck in the query. More likely, there are issues with the way the query is written, with indexing (missing indexes, indexes...

Thanks for your replies. So far my customer just sent me this brief Profiler Trace; I hope I could log on to the system ASAP so I could check the...

Cool! This works like a charm:-)

Thank you very much for this!

Cheers,

Jörg

Hi there,

well, I'm facing the same challenge: I need to convert a SID like "S-1-5-21-3188961675-671516999-2543839186-1000" into this "0x0105000000000005150000008BB113BE47890628D2E79F97E8030000" (or vice-versa).

Todd actually described a solution, but I'm afraid this exceeds my...

Hmm ... this does not work as I hoped ...

But: I found out that the standard sys.messages of severity "14" are not logged by default. So I set "WITH_LOG" to...

OK, I'm currently looking into various issues about "hardening" (createing roles, etc.).

According to that I would like to evaluate features to monitor the user access. So far I have created...