- What did you try ?

- I think it may work like the other queries in this list, don't you ?

This is out of my league at this moment.

I've launched a tweet using #sqlhelp and hope people will see and hop in.

Clear-Host

#first doing just get-item to pull over file details

get-item c:\temp\ibn\IBN_1_56_4960135.sqlplan

<# result

...

of course this restored db also holds the sysjobschedules table ...

Maybe you can also use a DTS/SSIS solution to pull over new data every x time, unless your systems need is actually real time or near time.

Did you consider a...

Indeed, this would cause less system overhead ...

get-item c:\temp\ibn\IBN_1_56_4960135.sqlplan | foreach -process {if ( $_.length -gt 0 ) { send mail here }}

also keep in mind, scalar functions come with a performance hit for sqlserver !

So, while you're at it, because you'll have to modify all referencing queries (views, sprocs, other functions,...

another powershell addict 😀

Me, myself and Powershell[/url]

did you try to redo the first unsuccessful log restore ? (the one that failed during your outage)

( or a restart of it )

I haven't had this kind of issue...

You mean something like :

This one will fail if you got circular references !

;with cteObjHirarchy

as (

select 1 as MyLevel

, -1 as FK_object_id

, O.object_id as ChildObjectId

...

My bet - and this is...

Thank you for the feedback.

- Can you post related Windows eventlog messages ?

- can you find anything in the sqlserver errorlog file ?

Did you try indexing your table for the columns in your query ?

As you are talking performance, with your current design, this query (and almost all queries for that matter)...

I would implement windows security for that purpose whenever I can.

( both for your usage as sqladmin as well as for the other person to use in that monitoring tool/service...