Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [process]

59 questions
31
votes
5 answers

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 When the work is ready for testing then the SQL…
Beth Lang
  • 952
  • 1
  • 10
  • 19
11
votes
3 answers

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 Windows Server 2008 R2 Enterprise (it is a Dell…
typefragger
  • 213
  • 1
  • 2
  • 6
10
votes
3 answers

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 topic! Many companies prevent developers from install…
Andy Neillans
  • 393
  • 1
  • 4
  • 10
10
votes
4 answers

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.creation_time, c.is_open, t.text FROM…
Racer SQL
  • 7,546
  • 16
  • 77
  • 140
9
votes
3 answers

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: INSERT INTO `tmpTbl` SELECT * FROM `realTbl` This…
Nanne
  • 285
  • 1
  • 3
  • 12
6
votes
1 answer

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 intermittently the following…
Vlad Mihalcea
  • 917
  • 3
  • 9
  • 23
5
votes
1 answer

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 of KILLED/ROLLBACK. However the SPID doesn't go…
David Mathis
  • 377
  • 1
  • 5
  • 12
5
votes
1 answer

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 MySQL. This is urgent as my online store is now…
Hector
  • 155
  • 1
  • 1
  • 4
5
votes
3 answers

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 actions. We have tried various ones and scrutinized the…
Trapper
  • 53
  • 1
  • 1
  • 3
5
votes
1 answer

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 a party and everyones invited. The thing is I…
1Up
  • 151
  • 1
  • 2
4
votes
2 answers

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 those things happen? (I'd find this useful during…
mahemoff
  • 331
  • 2
  • 14
4
votes
0 answers

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 check what's eating memory of one running query (it…
dsmoljanovic
  • 41
  • 1
4
votes
1 answer

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 the T:\ drive earlier. Again, there is 10MB…
Marcello Miorelli
  • 17,274
  • 53
  • 180
  • 320
4
votes
1 answer

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 idle. The legend says this is dangerous: Those…
Magier
  • 4,827
  • 8
  • 48
  • 91
3
votes
3 answers

Question about 'user process' in the context of Oracle

The following is an excerpt from Oracle's documentation: When a user runs an application program (such as a ProC program) or an Oracle tool (such as Enterprise Manager or SQLPlus), Oracle creates a user process to run the user's application. As…
Just a learner
  • 2,082
  • 7
  • 36
  • 57
1
2 3 4