What's the deal with Deno? We talk with a major contributor to find out. Listen now.

Questions tagged [process]

The tag has no usage guidance.

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

show detail processlist like at mariadb on maxscale

on mariadb when i need check what are query is running or sleep on mariadb instance. i can see with SHOW PROCESSLIST or select * information_schema.processlist. But after mariadb join and client ...
0
votes
0answers
24 views

SQL Server Service has stopped, but process still appears in TaskMgr

A customer has the strangest situation. Windows Server 2016 with SQL Server 2016. There is only one SQL instance on the machine (the default). Service name: MSSQLSERVER. The service take a very long ...
0
votes
0answers
37 views

NULL queries getting stuck and using up connections

Running show processlist in phpmyadmin for me often shows queries with an Info of NULL and a Time of apparently a few seconds, but which have in fact been stuck there for a long time (each time I run ...
1
vote
2answers
87 views

Differences between EDU and thread

In DB2, there is this command that shows active EDUs (engine dispatchable units): db2pd -edus There are two fields in the respective output: EDU ID and TID. According to this db2pd page from the DB2 ...
-3
votes
1answer
200 views

Sql Server consumes CPU but no one is using the server

In my server I have a SQL process that consumes CPU (~10%) but no one is using the server. In query select * from master.dbo.sysprocesses order by cpu desc I see at least one suspect process: spid: 9 ...
-2
votes
1answer
59 views

What do I do about blocked processes? [closed]

I am getting alerts stating: The SQL Server Performance counter 'Process Blocked' (Instance N/A) of object 'General Statistics' is now above the above threshold of 40 (the current Value is 41)" ...
1
vote
0answers
24 views

SQL Agent Job: Seeking Process flow advice on managing steps

Fellow DBAs, I need some practical advice on how to solve a job timing issue on different servers. I have a SQL Agent job that currently has steps 1-10. Step #8 has a dependency on a SQL Agent job on ...
1
vote
2answers
183 views

Memory threshold is attempted on SQL Server

Currently we have a monitoring for all the infrastructure (server, DB, network components, etc ...). The alert thresholds, usually saturation, are configured as follows: 90% : Warning 95% : Critical ...
1
vote
1answer
743 views

SHOW PROCESSLIST: show processes from all sessions

SHOW PROCESSLIST shows the list of processes for the current user and session only. Is there a way for the current user to list all their processes for all currently opened sessions?
1
vote
2answers
349 views

Symantec Backup Exec runing DBCC CheckDB and Backup on my SQL server

What is Symantec Backup Exec (TM)? I noticed that it is running in one the database server i am maintaining. I am a newbie in db administration and i am not sure what it is. It is running DBCC CheckDB ...
0
votes
1answer
1k views

What is “Field List” command in mysql processlist?

In my processlist, I see a long running process. There is no query, just the command "Field List" with an empty info column. Its been waiting almost 20 minutes on a table meta data lock on an ...
1
vote
0answers
70 views

How to set processes parameter in oracle 11g Windows in accordance with RAM in the server

Could anyone explain me whether there is any limitation in setting processes parameter in Oracle 11gr2 and how to set sga_target according to this. Right now I have set the processes to 4000 and I ...
4
votes
0answers
73 views

How to analyze postgres client process/session memory

Is there a way to check how much of process memory is allocated for the specific buffer for a running postgres session (work memory, temp buffers, plan cache etc ... )? I'm asking because i want to ...
1
vote
0answers
256 views

Reduce RAM required to process OLAP cube

I have a cube which I have created by using (in Visual studio) New Project -> Import from Server (Multidimensional and data mining). This cube is indeed created from the metadata of an already ...
0
votes
1answer
3k views

mongod runs with command but not with config file

I am trying to start mongod with a config file on MongoDB 3.2 on Ubuntu 14.04. I can launch mongod by issuing the command myself, but I can't get it to work with the config file. Here's the command ...
3
votes
1answer
9k views

DB Restart Taking too long, site is down

I tried to restart MySQL through WHM and now its taking way too long to restart, the progress bar is still showing. What can I do? I can still access the server via SSH but I cannot connect to ...
2
votes
0answers
991 views

How to unlock / repair mysql.sock

My issues have spawned from file permission changes leading to the popular ERROR! MySQL server PID file could not be found! error. However, I believe I've repaired them, but still cannot restart MySQL....
1
vote
1answer
430 views

Unable to query for thread information in mysql using root

I'm connected to a server's mySql database hosted on google cloud using the user 'root' with a password. I was under the impression that the root user had all privileges but when I try to get the ...
9
votes
3answers
3k views

Should developers be allowed to use LocalDB vs a “development” instance?

Much like the vein of the question that was posted here previously around "Should developers be able to query production databases?" I wanted to get your thoughts on another particularly annoying ...
0
votes
1answer
5k views

How to decide the parameter processes count? [closed]

I am using oracle 11g database and application deployed on weblogic 12.2.1 while I tried to access my application today, I faced an issue as "Listener refused the connection with the following error: ...
0
votes
0answers
60 views

backups taking longer to run, has anything within sql server changed?

The following is an email from one of my colleagues about an hour ago: Any Idea why the backup time has gone up from 2.5 hrs to 5.5 hours since the 16th Sept? The duration has remained ...
0
votes
1answer
1k views

is there a way to run the same job multiple times without scheduling it?

I have to run a process, and it says: --first see what is the situation with the job EXEC msdb.dbo.sp_help_job @job_name=N'Create new gift vouchers' EXEC msdb.dbo.sp_start_job N'Create ...
1
vote
3answers
17k views

Need to intentionally create blocking processes for testing

My team and I have an issue where we need to be able to identify processes that are blocking other processes and kill them. There are a ton of scripts that are freely available to perform these ...
3
votes
1answer
3k views

how to find out what process(es) caused the autogrowth of a database or a database file?

I have a process(es) hungry for tempdb, but I am struggling to identify this process. any ways I could achieve this? We have been alerted as Tempdb has now grown into the space you reclaimed on ...
1
vote
1answer
401 views

DELAYED User at MySQL

mysql> show processlist; | Id | User | Host | db | Command | Time | State | Info || 27098 | DELAYED | localhost | ...
1
vote
4answers
2k views

20 mysqld processes using only 1 port?

These are from Aliyun Cloud DB Servers,20 mysqld processes using one 3306 port Has anyone seen this before ? Can anybody explain how to do that ? Are there any advantages to this ?
1
vote
0answers
379 views

EXTPROC issue during 10g to 11g database

I am currently 10g to 11g database migration and trying to configure EXTPROC. EXTPROC32 was configured as part of 10g to execute C++ library and working fine. It appears that 11g does not provided ...
3
votes
1answer
588 views

Howto find out details and reasons for idle transactions?

I have started to use the "Idera SQL check" tool. It shows floating bubbles for each process active on the Sql Server system: Those bubbles are surrounded by a red border in case the transaction is ...
1
vote
0answers
46 views

MySQL using CPU after cancelling slow query

I had to cancel a very slow running query after it ran for a few days without completing on my Ubuntu server. Since then MySQL has been persistently running a process which is using 25-45% of the CPU ...
3
votes
1answer
4k views

SSAS cube process time increased after making fact and dimension small

I have a cube of 55 GB size which takes around 2 Hour to process full. As I have data for last 4 years but our business wants only 2 years of data. For that, I have changed dimension and Fact views to ...
1
vote
2answers
866 views

run job with uncommitted transaction - how to find the transaction? is it still active?

By mistake I have run the job I just put into production, but the COMMIT TRANSACTION was commented out. when I look at the job log, it printed that it did my updates with no problem. when I run ...
6
votes
1answer
59k views

Oracle intermittently throws “ORA-12516, TNS:listener could not find available handler with matching protocol stack”

While testing the Oracle XE connection establishing mechanism I bumped into the following issue. Although connections are closed on each iteration, after 50-100 connections Oracle starts throwing ...
9
votes
3answers
5k views

Lots of “FETCH API_CURSOR0000…” on sp_WhoIsActive ( SQL Server 2008 R2 )

I have a strange situation. Using sp_whoisactive I can see this: Ok, with this query, I can see what is triggering ( does this word exists in english? ) it: SELECT c.session_id, c.properties, c....
2
votes
1answer
414 views

What does Oracle use for handling a client connection (process or thread)?

SQL Server 2016 and MySQL 5.7 use thread-based connection handling. PostgreSQL 9.5 uses one operating system process for each individual connection. According to Oracle 12c documentation it's not ...
0
votes
1answer
42 views

How can I inform myself that an automatic SQL Server process has worked?

I have a Windows batch file which extracts some data from a remote system and then imports it into an instance of MS SQL Server 2014. The batch file runs SQLCMD and uses SQL files to bulk insert from ...
2
votes
0answers
144 views

Can data streams from Informatica to SQL Server be multi-threaded?

Suppose we have a database server, with SQL Server on it. And we are moving data from another database server, through our Informatica server, and onto that SQL Server database server. And our SQL ...
2
votes
1answer
6k views

MYSQL: log the query executed on certain table

I am writing a trigger that suppose to fire on inserts for a table and log the exact query used to insert. However, using below SELECT info INTO original_query FROM INFORMATION_SCHEMA.PROCESSLIST ...
5
votes
1answer
3k views

Too many mysql instances. How to kill?

I should be ashamed of myself, for asking, I know. Check out this screenshot attached. My server, which is indeed not seeing HUGE amounts of traffic, should not be this overloaded. Mysql is having ...
0
votes
1answer
705 views

Alter doesn't show in processlist

I'm performing an alter. It's currently running on a large table (300,000,000). MariaDB [my_database]> ALTER TABLE my_table -> add INDEX a (x, y, z), -> add INDEX d (x); Stage: 1 of ...
0
votes
0answers
799 views

How to tell which process in SQL Server I should kill?

I am having an issue with an application as it is running supper slow. I don't know if it is a database issue or something else as the is nothing that I can find to be the issue. I tried select * ...
0
votes
1answer
693 views

Postgres-9.1 having more Idle connections

The connections were created 2 days before. Can I kill the process manually by using the below query? select pg_terminate_backend(procpid) from pg_stat_activity where datname = 'mydb' and procpid <...
4
votes
2answers
1k views

Make MySQL server terminate when shell exits or on ctrl-c

If I run mysqld, ie invoke it directly on the command-line, it survives the shell being closed or hitting ctrl-c. Is there any way to run it "interactively", ie so that it will shut down if either of ...
0
votes
0answers
849 views

Oracle prevent CPU usage per process/session

I have an Oracle instance to which several applications from different machines connect (http servers). Normally Oracle CPU usage is ~5-10% even on high server loads. But from time to time, one of ...
3
votes
1answer
6k views

Monitor user to query processlist

We have a corporate monitoring system based in Zabbix. Its MySQL monitoring is quite basic, so I want to add more info. To do so, I've done a script that retrieves this info from MySQL and sends it to ...
2
votes
1answer
236 views

MySQL Start/Stop

Could anyone explain to me what happens during MySQL startup and shutdown? And i would like to know about the safe startup/shutdown process.
2
votes
2answers
91 views

How can I make this backup scheme more friendly for reporting?

Currently, we have around 50 remote servers, each with a production database. Each night, all 50 of these servers run a backup job and zips the backup. Each morning, a local server runs a job for each ...
1
vote
1answer
285 views

Should I use table hints with a process-keyed table?

I read on stackoverflow that locking can be a problem when using process-keyed tables, and I was wondering if you had any suggestions on how to minimize or avoid unnecessary contention (e.g. table ...
-1
votes
1answer
603 views

Why mysqld server service gets aborted when i start mysql client service? [closed]

I am installing mysql-5.5.7rc from source code. After installation when i start mysqld service is being run but as soon as i run mysql client service server service gets aborted.. And also ...
12
votes
3answers
10k views

SQL Server 2008 R2 “Ghost Memory”?

We have a dedicated SQL Server 2008 R2 machine that is experiencing some strange memory issues.. The machine itself has plenty of resources including two quad-core processors, 16gb of RAM and 64bit ...
6
votes
2answers
25k views

Internal reason for killing process taking up long time in mysql

I copied a big table's structure with (it is an InnoDB table btw) CREATE TABLE tempTbl LIKE realTbl Then I changed an index, and filled it up so I could run some test. Filling it was done using: ...