Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MDW and upload schedules from different instances Expand / Collapse
Author
Message
Posted Monday, March 25, 2013 6:08 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 25, 2014 1:02 AM
Points: 24, Visits: 318
I have recently set up MDW across our SQL estate. There are approximately 40 instances being monitored all sending their data to a cental sysutility_mdw database. I started to run into issues with uploads failing and timing out so I staggered the upload schedules. Each set of upload jobs from an instance still kicked off at the same time (every 15 mins) but only happening once a day. However, wheh I now look at the reports a No Data Availble message appears despite the upload completed without errors.

I then staggered one set of uploads to start 2 minutes apart to upload every 15 mins and every 17 mins and this report is now displaying data again.

If the upload only happens once a day, where has the data gone? Each of these is running in cached mode, so I assumed all data for last 24 hours would just be uploaded, but this is not the case?

Can anyone shed any light on this?

In terms of locking issues on the sysutility_mdw database, what would be the best upload schedule? If I have 10 instances, should the upload times be staggered from each instance so data is hitting the sysutility_mdw database at different times, or is it safe to just stagger the upload times between jobs on the one instance, but upload the data at the same time from all instances? Or should each instance have it's own MDW database?

Hope this makes sense?
Post #1435207
Posted Wednesday, May 1, 2013 9:26 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 25, 2014 10:48 AM
Points: 11, Visits: 277
I'm not sure I can help with your situation or not, but I recently had upload problems myself. They appeared out of the blue. I reviewed the following articles:

http://thesqldude.com/tag/mdw/
http://support.microsoft.com/kb/980497

The first article is a very nice accumulation of various problems and some resolutions. The second article applied to my particular situation. When I opened the properties of Data Collector, there was no default path to the *.cache files listed. I set the troubled instance paths to X:\MyDataDrive\MySQLInstancePath\MSSQL\JOBS\UtilityDC and wahlah...it started working again. I'm not sure what caused the original problem because it was working fine.

Lastly, depending on what version of SQL you are running, you are limited to the number of instances you can enroll. You'll need to confirm these numbers, but I believe it's 25 enrolled instances for Enterprise and 200 enrolled instances for DataCenter. Not sure which you have, but you mentioned having 40 enrolled instances.

HTH!!
Post #1448481
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse