What is the corruption or damage that you are referring to here ..

--

SQLBuddy

Yes, you can use either way. Use Linked Server (LS) for short and less complex queries. SSIS is recommended as you can do much more using it than a LS.

--

SQLBuddy

You are welcome .. 🙂

--

SQLBuddy

Try running the job using SSIS agent proxy with your credentials

--

SQLBuddy

Did you install any updates or drivers or any firm-ware upgrade on the DB server recently ..

--

SQLBuddy

I feel it's a better way to do the monitoring and easy to interpret as it's an exclusive report for Resource Governor and less likely to misintrepret ..

--

SQLBuddy

I think it's not like it works only on Win 2008 R2. May be they didn't test it on other...

They work for me fine. Did you copy them to C:\Users\YourUserName\Documents\SQL Server Management...

If the Classifier function is working as expected, may be there's some issue with perfmon monitoring ..

Try using this report ..

http://blogs.msdn.com/b/sql_pfe_blog/archive/2013/06/20/sql-server-resource-governor-monitoring-reports.aspx

--

SQLBuddy

New Born DBA (2/27/2014)

---

Fortunately QA[/quote

If you don't take TLog Backups, you can't restore the data back to the point in time in case of a disaster and TLogs will be...

Actually it's waiting for a transaction log backup to truncate the log. Is this on a Production Server ?

--

SQLBuddy

what is the error message ..

--

SQLBuddy

You can use this..

GRANT EXECUTE ON SCHEMA::dbo TO Name;

--

SQLBuddy

No, XP is not supported for SQL 2012 ..

--

SQLBuddy

LowPriorityPool should not be 25% CPU as the Max was 20%. May be the classifier function is not working properly and

the requests are getting redirected to the default workload group....