Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2010-03-10 : 05:01:37
|
| Hi,Have a question, when i issue a BACKUP cmd for a database and issue the sp_who cmd, instead of showing one entry for spid = 57, why it is showing 3 entries.Why can't it show's only 1 entry in the output. This is not the case of BACKUP Command. I have also observed for other commands.Can anyone give any specific reasons for this ??????backup database dcdbset2 to disk = 'd:\Test_db.bak'sp_who--output/*spid ecid status loginname hostname Blk dbname cmd57 0 runnable sa MACHINE-1 0 Test_db BACKUP DATABASE 57 2 runnable sa MACHINE-1 0 NULL BACKUP DATABASE 57 1 runnable sa MACHINE-1 0 NULL BACKUP DATABASE */Thanks in Advance. |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2010-03-10 : 06:01:20
|
quote:
Originally posted by frank.svs
spid ecid status loginname hostname Blk dbname cmd57 0 runnable sa MACHINE-1 0 Test_db BACKUP DATABASE 57 2 runnable sa MACHINE-1 0 NULL BACKUP DATABASE 57 1 runnable sa MACHINE-1 0 NULL BACKUP DATABASE */Thanks in Advance.
If u examine the result set u will see that there are 3 ecid for spid 57.As defined by MS ecid is quote:
The execution context ID of a given thread associated with a specific SPID.ECID = {0, 1, 2, 3, ...n}, where 0 always represents the main or parent thread, and {1, 2, 3, ...n} represent the sub-threads.
from [url]http://msdn.microsoft.com/en-us/library/aa260384(SQL.80).aspx[/url] |
 |
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2010-03-11 : 04:17:56
|
| Thank you |
|
|
|
|
|
|
|
|
sp_who