getting blocking alerts by SQLDMO_1

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

getting blocking alerts by SQLDMO_1

Author

Topic

venkath
Posting Yak Master

202 Posts

Posted - 2007-05-24 : 09:27:25

Hi All

I am getting this alerts during a certain period of a day.

I checked for spid of 6

SPID Blocked program_name
399 6 SQLDMO_1

when i issued SP_WHO2

I got the following info

6    	sleeping                      	sa	  .	  .  	D3DB	CHECKPOINT      	0	11090	05/14 13:42:28	                                                                         	6

where D3DB is a production database name
SPID 6 is a checkpoint background process

Can any one help me what is SQLDMO_1, what does it have to do with the checkpoint process.

Thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-24 : 10:04:59

This is system process to perform checkpoint.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources