Questions tagged [management-data-warehouse]

SQL Server Management Data Warehouse

Filter by
Sorted by
Tagged with
0 votes
0 answers
20 views

Dynamic dimension design and its effect on other hierarchical dimensions in sql server

I have a fundamental problem for the implementation of my company's data warehouse. My company's business is delivering customers' orders, and on days when stores have promotions, we have a severe ...
0 votes
0 answers
57 views

Data warehouse Design: Parking lot

I came across a data warehousing practice question which Involved design a data warehouse for vehicle parking data, Design Considerations: Vehicle -> 2 wheeler -> Weekday -> 1$ (fare per hour)...
  • 101
1 vote
0 answers
30 views

How are the relations from Relational Database mapped to DataWarehouse?

this year one of our collage courses was related to creating and managing data warehouses. There is one thing that I really struggle to understand and I would appreciate any kind of advice that you ...
1 vote
0 answers
22 views

SQL Server Management Data Warehouse creates a lot of sleeping user connections

I am wondering if someone already experience this weird scenario regarding my SQL Server Management Data Warehouse; it creates a lot of user connections. Around 2500 connections which were all ...
0 votes
1 answer
286 views

Configuring SQL Server management data warehouse (MDW) for data collection

I am configuring a data warehouse on an SQL Server to collect data. However, the process is not finishing and it stays as per below for hours until it is manually stopped: Have you ever encountered ...
3 votes
1 answer
262 views

MDW Data Collector Server Activity collection step 3 suddenly stopped working [closed]

For many weeks my data collections from my database instace have been uploading to my MDW server. Suddenly step 3 of the Server Activity Collector has stopped working giving the following error: Job ...
4 votes
1 answer
1k views

Server Activity data collector job fails due to performance counters

tl;dr: what Windows permission / configuration is needed for the "Server Activity" data collection job to run successfully? I'm running SQL Server 2016 SP1 CU6 (13.0.4457.0) on Windows Server 2012 R2 ...
  • 28.5k
0 votes
1 answer
195 views

Management Data Warehouse Database

We have a MDW Database in our PROD Server of size 40GB. I can see all the collector Jobs are not running properly and the purging MDW job. mdw_purge_data_[ManagementDWH] is not running saying the ...
2 votes
0 answers
530 views

Query Statistics in management data warehouse empty

i am using management data warehouse form SQL Server 2012. I used it before on a 2008 instance a few years ago and everything worked good. However this time i cannot see any Query Stastics data ...
  • 321
2 votes
1 answer
267 views

Error When Trying to Run MDW Data Collector

I have SQL Server Management Data Warehouse (MDW) set up across multiple instances, all in the same way with the same accounts and permissions. On one server I get an error when trying to run the ...
2 votes
1 answer
962 views

SQL Server MDW - Query for data collector retention period

I have data collectors active on many remote servers and I am trying to find a query that will capture the retention periods for all data collectors active on an instance. These are system data ...
  • 215
4 votes
2 answers
26k views

Query to calculate database growth

I have the following query that outputs some good information from MDW data collectors regarding database space usage. I am wondering with the following columns (db size, reserved space, unused space, ...
  • 165
4 votes
1 answer
127 views

Scripting Microsoft Data Warehouse Wizard

I am trying to automate the MDW setup process in my environment. Currently I have everything complete except for enabling the data collectors (usually uses a wizard as seen ). Has anyone seen or ...
  • 165
1 vote
1 answer
703 views

Proxy for MDW data collection on remote servers - SQL Server 2012

I am trying to setup data collection (for disk usage) from remote servers and upload it to my MDW database. I understand I will need a proxy set up for the agent to do this but which subsystem to I ...
  • 165
1 vote
1 answer
261 views

SQL Server configuring both UCP and MDW on a single server

I'm trying to configure both UCP and MDW on a SQL Server. I have already setup UCP and it created [sysutility_mdw] database. Now when i try to setup MDW it is trying to use sysutility_mdw database ...
  • 13
1 vote
1 answer
81 views

Separating system databases from MDW SQL Server 2008 R2

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 ...
user avatar
3 votes
1 answer
714 views

Migrate Management Data Warehouse to a New Instance

Is there a defined procedure to follow for moving a SQL Server 2012 Management Data Warehouse to a new server\instance? We intend to setup MDW on a test SQL Server instance first, but will then want ...
  • 131
2 votes
1 answer
505 views

mdw_purge_data_ long runtime

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 ...
user avatar
8 votes
1 answer
36k views

SQL Server 2008 R2 high Buffer I/O causes

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 ...
user avatar