Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [data-collection]

20 questions
5
votes
3 answers

Cannot generate reports from SQL Management Data Warehouse

I'm running SQL Server 2008 R2 and have installed the MDW on one server and have a Data Collector collecting and uploading the server activity, query results, and Disk activity data to the MDW. When I select any of the reports from the MDW with Data…
Rita
  • 51
  • 1
  • 2
4
votes
1 answer

Teradata : Disadvantage of Collect stats

I want to know any disadvantage can occur by doing collect stats on a column that is being widely used in join condition across so many procedures ? (Eg. the column is accessed 300+ times access in 60 days) While searching in google, i came to know…
Sinoop Joy
  • 51
  • 1
  • 1
  • 4
4
votes
1 answer

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 Datacenter. Whenever I try to run the "Server…
Josh Darnell
  • 30,133
  • 5
  • 70
  • 124
4
votes
2 answers

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, unallocated space, collection date) how can i…
choloboy7
  • 165
  • 1
  • 2
  • 9
3
votes
1 answer

Data Collection reports fail because login is from an untrusted domain

I've set up a data warehouse and Data Collection according to BO. Reports are generated properly when running them in Management Studio running on the server but fail when they are run from Management Studio on a different machine (which is using…
gemisigo
  • 343
  • 1
  • 3
  • 12
2
votes
1 answer

MDW performance_counter_instances table running out of identity values

My MDW database's performance_counter_instances table has run out of identity values. Has anyone ever encountered this? Is it safe to change the data type of the identity field performance_counter_id from INT to BIGINT without breaking…
Alf47
  • 981
  • 1
  • 9
  • 22
2
votes
1 answer

SQL Data Collector - SSIS required on source server?

For SQL Data Collector: Do you need SSIS (SQL Server Integration Services) installed on the server that you are collecting data from. Or can the packages be run from another server -- like the one that the MDW database is on.
Craig
  • 513
  • 1
  • 5
  • 11
2
votes
2 answers

What is the difference between using First..Last and 1..count in Oracle?

What is the difference between using First..Last and 1..count in Oracle? FOR i IN l_collection.FIRST..l_collection.LAST LOOP or FOR i IN 1..l_collection.COUNT LOOP
user114198
  • 181
  • 1
  • 2
  • 6
1
vote
1 answer

dcexec login failure

I have a SQL Server 2008 R2 instance that I have been trying to get Data Collection setup on. I get everything setup, but there is no data that gets uploaded. I've traced the root of the problem to be a failure in the SQL Agent jobs where it calls…
Elijah W. Gagne
  • 705
  • 2
  • 12
  • 22
1
vote
1 answer

Is there a generator to create a table in MongoDB just like in Laravel?

I'm a newbie in mongoDB, and I just would like to ask a simple question. In creating tables in MongoDB, do you go ahead in MongoDB compass and create the fields in a collection, or is there a command where you can generate the table fields declared…
Jumar Juaton
  • 13
  • 2
1
vote
1 answer

Cannot Update a System Collection Set

I'm trying to tweak the "Server Activity" Data Collection set as outlined in this blog post (I wrote the post, btw. Sorry--it's kinda long). It is working in SQL 2008 R2 and also in SQL 2014. However, when I run…
Dave Mason
  • 875
  • 1
  • 8
  • 19
1
vote
1 answer

Collection of different types of data in a relational database

Let's say I have a table Cars (with columns such as model, make, year, etc.), a table Books (with columns such as name, author, ISBN, etc.) and a table Wines (with columns such as name, appellation, region, vintage, etc.) Now, even if these tables…
Vinch
  • 113
  • 3
0
votes
1 answer

Will column size change when trying to use single unicode character in place of multiple ASCII characters?

I have a column in utf8_unicode_ci collation for text type in MySQL. The content is in Unicode, I have used tags like {br}, {v}, {t}, {h} etc.., throught the database. I am now thinking of changing these to single characters from Unicode table like…
Jayarathina Madharasan
  • 103
  • 4
0
votes
1 answer

What's the point in mapping users in SQL Server Data Collection?

In SQL Server 2012 R2 Enterprise, whenever I check Management\Data Collection, right-click --> Configure Management Data Warehouse , I see whatever users-accounts-logins except the one I am logged in I cannot understand what's the point in "Map…
Fulproof
  • 1,392
  • 2
  • 26
  • 36
0
votes
1 answer

What are the typical uses of the Data Collector?

The Data Collector is the single most obscure SQL Server concept that I know of. I have never even seen it mentioned in a professional or educational context, never mind used. I don't even think that it has a tag on this website, although I have…
J. Mini
  • 1,161
  • 8
  • 32
1
2