If you are set on having a GUI, you might look into using template prompting. It doesn't give you the ability to use drop-down lists, but can give you...

Ok, well, thats not fully true. If I have to go the "Shell" way, I'd rather user PowerShell (which I currently...

Thank you very much for your response!

No, SQLCMD is definitely not an option. But I like the approach with JSON/SP!

Though, still not a convenient GUI-Wizard but as you say, a...

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