September 6, 2016 at 8:53 am
Hello All,
I have setup a MDW and it was working fine until recently. Now I get No Data Available. How do I troubleshoot it?
Thanks.
September 6, 2016 at 9:06 am
ichervin (9/6/2016)
Hello All,I have setup a MDW and it was working fine until recently. Now I get No Data Available. How do I troubleshoot it?
Thanks.
Honestly you simply stop using it. I have never, ever heard of a single entity using this mess and it should never have been done by the SQL Server product team in the first place IMNSHO. :crying:
There are very solid free, cheap and expensive options for monitoring SQL Server.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
September 6, 2016 at 9:09 am
Can you list some of them?
September 6, 2016 at 9:58 am
sp_whoisactive can be put into a table and track/trend
Glenn Berry's SQL Server Diagnostics scripts have lots of things you can store in a table and track/trend (file IO stalls and wait stats are the most important things to keep an eye on obviously).
Redgate and ApexSQL have what I will term "value" monitoring tools, although Redgate's has become quite capable.
SQL Sentry, Dell (formerly Quest Doftware), Idera have more up-market/complex/expensive tools.
Someone on SSC.com just realeased version two of their baseline performance collector that at first glance I really liked.
Steve Steadman has a freebie I have been watching develop for some time now. Quite impressive.
SCOM has a SQL Server pack.
I am sure there are plenty I didn't mention.
MDW needs to be completely disabled and removed from your life. 🙂
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
September 8, 2016 at 2:40 am
If you want basic dashboard capability have a look at what I setup over on codeplex.
https://sqldashboards.codeplex.com/
You may / may not like it - buts its worth a go setting it up.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply