Skip to main content
9 votes
Accepted

Need to intentionally create blocking processes for testing

BEGIN TRANSACTION SELECT * FROM YourTable WITH (TABLOCKX, HOLDLOCK) WAITFOR DELAY '00:05:00' -- 5 minutes ROLLBACK TRANSACTION And then in another Query Window: SELECT * FROM YourTable
Jason B.'s user avatar
  • 642
6 votes

Should developers be allowed to use LocalDB vs a "development" instance?

To me all these arguments are particularly invalid Ok. But they aren't to the rest of us. Why? Patch level consistency between development servers and production the patching would be proven out ...
Cody Konior's user avatar
  • 3,508
6 votes
Accepted

Should developers be allowed to use LocalDB vs a "development" instance?

Yes. All developers should have a local instance of SQL Server AND a shared SQL server instance. They exist for different purposes. Both are needed. Perhaps your current environment looks like ...
Troy Witthoeft's user avatar
5 votes
Accepted

how to find out what process(es) caused the autogrowth of a database or a database file?

The only way to find out what process caused the autogrowth is to use Extended events esp. EVENT --> sqlserver.database_file_size_change & sqlserver.databases_log_file_size_changed and ACTION --> ...
Kin Shah's user avatar
  • 62.3k
5 votes

Should developers be allowed to use LocalDB vs a "development" instance?

Conceptually speaking, you are on the right track. For an organization that has a mature development process / Software Development Life Cycle (SDLC) that includes source code control, continuous ...
Solomon Rutzky's user avatar
4 votes

Need to intentionally create blocking processes for testing

This is pretty easy to do. Open two query windows in Management Studio. Run something like this in the first one (choose a test table that nobody is using, because this will block them, and make sure ...
db2's user avatar
  • 9,668
4 votes

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. There are many background tasks that run, regardless of user activity inside of SQL Server. The key is to ...
Sean Gallardy's user avatar
4 votes
Accepted

DB Restart Taking too long, site is down

Without seeing any additional information, here is my best guess why MySQL is trying to shutdown for a long time: I suspect mysqld no longer has a socket file. About 1.5 years ago, I answered mysql ...
RolandoMySQLDBA's user avatar
3 votes
Accepted

Differences between EDU and thread

EDU is an abstraction over the underlying OS scheduling unit, a sort of a surrogate key assigned to whatever is doing actual work in the OS. If the OS has true threads, distinct from processes, such ...
mustaccio's user avatar
  • 26.2k
3 votes

Symantec Backup Exec runing DBCC CheckDB and Backup on my SQL server

I'm not sure if Symantec still owns it, but Backup Exec is Netbackup's little brother. I don't remember the feature differences but Netbackup is more for Enterprise environments and Backup exec for ...
Alen's user avatar
  • 539
3 votes

What do I do about blocked processes?

First you need to determine whether the blocking is a problem or not. Some applications are going to have numerous connections running INSERTS, UPDATES, or DELETES as fast as they can. This is by ...
Tony Hinkle's user avatar
  • 7,964
2 votes

Memory threshold is attempted on SQL Server

Sadly, sometimes we get less than helpful information to deal with throughout our busy days. Q. What do Quantified Alerts tell us? That service A is doing or enduring something. That information is ...
clifton_h's user avatar
  • 677
2 votes
Accepted

SHOW PROCESSLIST: show processes from all sessions

Obtain this info from information_schema.PROCESSLIST. If your user have PROCESS privilege, and you need to view only your processes - use WHERE user = USER() filter. Link
Akina's user avatar
  • 20k
2 votes

Symantec Backup Exec runing DBCC CheckDB and Backup on my SQL server

What is Symantec Backup Exec (TM)? Symantec Backup Exec is a backup software that works on many types of platforms in your environment. One of those features is to back up SQL Server Databases. It ...
Shaulinator's user avatar
  • 3,142
2 votes

What is "Field List" command in mysql processlist?

Look for any lines in the PROCESSLIST with a Time higher than that one (1188). It probably indicates the villain. The owner of both rows may give a clue. A "metadata lock" involves something other ...
Rick James's user avatar
  • 78.5k
2 votes

Unable to query for thread information in mysql using root

This is something you quickly learn with GCP (CloudSQL), AWS (RDS), and all Cloud Providers of MySQL: Even root does not have all privileges. You could run SHOW GRANTS when logged in as root. ...
RolandoMySQLDBA's user avatar
2 votes
Accepted

is there a way to run the same job multiple times without scheduling it?

I've been using the following stored procedure (I can't even remember where I got the code from) for a long time. It allows you to start a job and waits for the job to complete before returning ...
Scott Hodgin - Retired's user avatar
1 vote
Accepted

How to decide the parameter processes count?

Yes, it depends on your user count. But not only that, it also depends on which way your users connect to the database and the number of background processes your instance requires. There are ...
Daniela Petruzalek's user avatar
1 vote

track down which application / procedure / function modified the value of a column in a specific table

This might get you going along the right track. You pass the sql_handle of the existing connection to the table valued function sys.dm_exec_sql_text, and it returns the SQL text being executed. If ...
datagod's user avatar
  • 7,101
1 vote

Need to intentionally create blocking processes for testing

You could also fire this off in a few concurrent sessions. Only one session will be able to get the exclusive lock at any one time. BEGIN TRANSACTION; EXEC sp_getapplock @Resource = 'FooBar', ...
Martin Smith's user avatar
  • 84.9k

Only top scored, non community-wiki answers of a minimum length are eligible