Question : In SQL Server 2012 R2 Enterprise, whenever I check ManagementData Collection, right-click –> Configure Management Data Warehouse , […]
Tag: data-collection
Management Data Warehouse SQL Server data collection reports [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
SQL Data Collector – SSIS required on source server?
Question : For SQL Data Collector: Do you need SSIS (SQL Server Integration Services) installed on the server that you […]
Cannot generate reports from SQL Management Data Warehouse
Question : I’m running SQL Server 2008 R2 and have installed the MDW on one server and have a Data […]
Will column size change when trying to use single unicode character in place of multiple ASCII characters?
Question : I have a column in utf8_unicode_ci collation for text type in MySQL. The content is in Unicode, I […]
Will column size change when trying to use single unicode character in place of multiple ASCII characters?
Question : I have a column in utf8_unicode_ci collation for text type in MySQL. The content is in Unicode, I […]
MDW performance_counter_instances table running out of identity values
Question : My MDW database’s performance_counter_instances table has run out of identity values. Has anyone ever encountered this? Is it […]
Server Activity data collector job fails due to performance counters
Question : tl;dr: what Windows permission / configuration is needed for the “Server Activity” data collection job to run successfully? […]
Performance Monitor % Processor Time metric difference between _Total and sqlservr.exe
Question : I have SQL Server running on 32-core CPU, and I use Performance Monitor (perfmon.msc) to collect data on […]