Questions tagged [data-collection]
The data-collection tag has no usage guidance.
21
questions
0
votes
0
answers
15
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 ...
- 101
0
votes
0
answers
21
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 ...
- 101
1
vote
1
answer
149
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 ...
- 13
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 ...
- 53
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
- 103
0
votes
1
answer
387
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 - ...
- 5,144
0
votes
1
answer
117
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....
- 349
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
2
votes
1
answer
7k
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
- 131
1
vote
1
answer
365
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,...
- 845
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 ...
- 167
1
vote
1
answer
236
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, ...
- 113
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
0
votes
1
answer
72
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 ...
0
votes
1
answer
100
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 ...
- 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 ...
- 695
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 ...
- 51
2
votes
1
answer
617
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 ...
- 941
2
votes
1
answer
823
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 ...
- 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 ...
- 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 ...
- 333