Questions tagged [process]
The process tag has no usage guidance.
48
questions
-3
votes
1answer
104 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
56 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
19 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
99 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
530 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
214 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 ...
-1
votes
1answer
524 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
63 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
62 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
187 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
6k 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
796 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
258 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 ...
8
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
3k 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
986 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
13k 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
266 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
291 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
424 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 ...
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
749 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
...
5
votes
1answer
44k 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
370 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
41 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
131 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
4k 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
571 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
701 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
591 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
830 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
5k 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
199 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
263 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 ...
0
votes
1answer
529 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
20k 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 ...
2
votes
3answers
2k views
Question about 'user process' in the context of Oracle
The following is an except from oracle documentation.
Overview of User Processes
When a user runs an application
program (such as a Pro*C program) or
an Oracle tool (such as Enterprise
...
31
votes
5answers
2k views
Is there a “best-practices” type process for developers to follow for database changes?
What is a good way to migrate DB changes from Development to QA to Production environments? Currently we:
Script the change in a SQL file and attach that to a TFS work item.
The work is peer-reviewed
...
