Sql server back ground processes.

Question

Sql server back ground processes.

solomon.jernas

Hall of Fame

Points: 3680
More actions
March 19, 2013 at 9:25 am

#272361

I want to know , when i am execute sql select query , what are processes will be running in background
Please

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Orlando Colamatteo SSC Guru Points: 182276 More actions · Answer 1

You mean other than the query executing and the retrival of data occurring? What is the root of your question? Can you be more specific?

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

solomon.jernas Hall of Fame Points: 3680 More actions · Answer 2

i want know, while i am executing select query , what are proceses running in background ?

Can you explain about that..

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

There are lots of processes running in the background all the time. Query sys.dm_exec_sessions and filter for is_user_process = 0. That'll show you all the background system processes.

They aren't specific to a query, they're always there, running in the background as SQL needs.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

solomon.jernas Hall of Fame Points: 3680 More actions · Answer 4

OK.

But i want know, this way , thread and cost of query , lazy writer, memory . what are things involve in DML query.. Architure level in depth concept

Lowell SSC Guru Points: 323504 More actions · Answer 5

there's far more information out there than we can provide in a simple forum post; forum posts are great for specific questions, but not so much for general research.

i guess you'll want to google a bit for something like "sql server statement processing steps" or "SQL Server processor internals"

the first hit for that i thought was relevant:

http://msdn.microsoft.com/en-us/library/ms190623(v=sql.105).aspx

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

solomon.jernas (3/20/2013)
But i want know, this way , thread and cost of query , lazy writer, memory . what are things involve in DML query.. Architure level in depth concept

Cool.

Watch all of these:

http://www.sqlskills.com/T_MCMVideos.asp

Read all of this:

http://www.sqlskills.com/MCM.asp

It's several books worth, so you'll forgive me I hope for not explaining everything here.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass