Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 20442

SQL Server Management Data Warehouse

8
votes
1answer
Am trying to troubleshoot performance on a SQL Server that we have for our document management server and today performance has hit an all time low. Looking at the Management Data Warehouse (MDW) I …
asked Mar 15 '13 by Tim Alexander
2
votes
1answer
I have a SQL Server 2008 R2 that is running several databases and has also been configured as our central MDW. When the management data warehouse is created it creates a number of agent jobs one of … : http://www.toddbaker.org/blog/2010/12/17/sql-2008-mdw-fixing-long-running-purges/ This does not seem to have helped. I then read another blog post suggesting creating two indexes on the sql_handles …
asked May 9 '13 by Tim Alexander
2
votes
So finally sorted this out. There was an orphaned instance within the MDW. I removed this, which took at least a day to kill off. Trying to create the indexes failed through the gui due to a time … out. Using activity monitor I could see that there were still huge waits on the server. I stopped all data collection for the MDW and disabled all the jobs associated, including the purge job. I …
answered May 13 '13 by Tim Alexander
1
vote
1answer
We have the Management Datawarehouse feature configure on two of our SQL Servers. Both point to the same central database and upload their results to it. Everything works fine with the built in repo …
asked Sep 24 '14 by Tim Alexander