Questions tagged [data-collection]

The tag has no usage guidance.

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

What is the best way to track user ip and id for the page visits

I am 15 pages in my site. I want to track the guest user (through IP) & loggedin user (through userid) for all the pages. What I have schema is: Create a table; create one entry; and make 15 ...
user avatar
  • 101
1 vote
1 answer
22 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 ...
user avatar
0 votes
1 answer
1k 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 ...
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
user avatar
  • 103
0 votes
1 answer
277 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 - ...
user avatar
0 votes
1 answer
108 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....
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 ...
user avatar
  • 27.2k
0 votes
0 answers
209 views

How to Configure Management Data Collection through SSMS without Installation error?

I am trying to configure Management Data Warehouse Wizard from SSMS for Data collection. Getting error message at step2: Run Installation Script on Database. Error message info in below: Run ...
user avatar
  • 1,427
2 votes
1 answer
6k 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
user avatar
  • 131
1 vote
1 answer
349 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,...
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 ...
user avatar
  • 167
1 vote
1 answer
225 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, ...
user avatar
  • 113
4 votes
2 answers
25k 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, ...
user avatar
  • 165
0 votes
1 answer
69 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 ...
user avatar
0 votes
1 answer
99 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 ...
user avatar
  • 1,362
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 ...
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 ...
user avatar
2 votes
1 answer
593 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 ...
user avatar
  • 941
2 votes
1 answer
793 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 ...
user avatar
  • 501
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 ...
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 ...
user avatar
  • 323