Questions tagged [data-collection]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
62 views

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 ...
J. Mini's user avatar
  • 89
0 votes
0 answers
22 views

Why is it that when filtering by two collections, the execution time increases significantly and the query takes a very long time?

Given: A table with 6 million records. We need to collect some statistics for the quarter. 650 thousand lines fall into the quarter. The data filtering parameters come into the procedure. Some of ...
SwaD's user avatar
  • 101
1 vote
1 answer
259 views

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 ...
Jumar Juaton's user avatar
0 votes
1 answer
2k views

InfluxDB with Zabbix or Telefraf?

I'm considering the use of InfluxDB to store thousands of measurements per second from routers in a network. Each measurement is lightweight (between 10-20 bytes). Now, I'm wondering what is the ...
Daniel S.'s user avatar
0 votes
2 answers
3k views

clone collection in mongoDB in the same db

I want ti copy my collection including is indexes without the data. how can I do it in the most efficient way? I am using a replica set version 4.0.3
NoamiA's user avatar
  • 103
0 votes
1 answer
480 views

Performance Monitor % Processor Time metric difference between _Total and sqlservr.exe

I have SQL Server running on 32-core CPU, and I use Performance Monitor (perfmon.msc) to collect data on Processor: % Processor Time (Instance - _Total) and Process: % Processor Time (Instance - ...
Aleksey Vitsko's user avatar
0 votes
1 answer
128 views

Management Data Warehouse SQL Server data collection reports [closed]

I configured MDW on an SQL Server instance but when I try to access the reports from the MDW DB, the reports show information until a couple of days ago and I am getting 'collection set is not running....
user1930901's user avatar
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 ...
Josh Darnell's user avatar
  • 29.2k
2 votes
1 answer
8k views

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's user avatar
1 vote
1 answer
402 views

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,...
Dave Mason's user avatar
0 votes
1 answer
2k views

Execute immediate call causes 'variable not in select list' error

Execute immediate call causes 'variable not in select list' error hi there, i'm practicing with collections and execute immediate by combining them in plsql and have the following code: set ...
bofanda's user avatar
  • 167
1 vote
1 answer
240 views

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, ...
Vinch's user avatar
  • 113
4 votes
2 answers
28k 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, ...
choloboy7's user avatar
  • 165
0 votes
1 answer
76 views

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 ...
Jayarathina Madharasan's user avatar
0 votes
1 answer
104 views

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 ...
Fulproof's user avatar
  • 1,382
1 vote
1 answer
2k views

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 ...
Elijah W. Gagne's user avatar
4 votes
1 answer
2k views

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 ...
Sinoop Joy's user avatar
2 votes
1 answer
630 views

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 ...
Alf47's user avatar
  • 961
2 votes
1 answer
845 views

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 ...
Craig's user avatar
  • 503
5 votes
3 answers
3k views

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 ...
Rita's user avatar
  • 51
3 votes
1 answer
2k views

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 ...
gemisigo's user avatar
  • 343