Questions tagged [process]
The process tag has no usage guidance.
16
questions with no upvoted or accepted answers
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 ...