Questions tagged [process]
The process tag has no usage guidance.
52
questions
0
votes
0answers
20 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
34 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
63 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 ...
-3
votes
1answer
162 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
57 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
21 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
120 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
683 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
296 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
738 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
69 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
67 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
219 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
2k 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 ...
2
votes
1answer
7k 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
878 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
329 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
2k 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
4k 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
15k 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
2k 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
313 views
DELAYED User at MySQL
mysql> show processlist;
| Id | User | Host | db | Command | Time | State | Info || 27098 | DELAYED | localhost | ...
1
vote
4answers
1k 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
329 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
490 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
804 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
49k 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
4k 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
382 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
140 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
5k 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
2k 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
627 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
761 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
622 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
841 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
206 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
90 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
270 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
572 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
9k 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 ...
7
votes
2answers
22k 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:
...
5
votes
1answer
5k views
Unable to kill SPID
I have a SQL Server 2005 Std (x64) with SP4 that has a procedure I cannot seem to kill. If I view sys.dm_exec_requests I see SPID 103 with wait_type of LCK_M_SCH_M, a status of SUSPENDED and command ...
