Questions tagged [process]

The tag has no usage guidance.

16 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
0answers
91 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 ...
2
votes
0answers
1k 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....
2
votes
0answers
152 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 ...
1
vote
0answers
25 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
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 ...
1
vote
0answers
276 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 ...
1
vote
0answers
414 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 ...
1
vote
0answers
47 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 ...
0
votes
0answers
5 views

Merge multiple InfluxDB 1.8 dbs into one + add tags with names of dbs

I have multiple InfluxDB 1.8 databases with same schema but different names of databases. I need to merge them all into one database + add a tag with name of original database the data came from so I ...
0
votes
0answers
22 views

MongoDB too many forked processes

We are having an issue with the MongoDB high usage memory, this is an AWS EC2 server running only MongoDB on docker container. total used free shared buff/cache ...
0
votes
1answer
24 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
40 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
52 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 ...
0
votes
0answers
61 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
0answers
821 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
0answers
852 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 ...