Any option shrink in mirrored db or only log backup will shrink the log size.

150 GB is occupied disk and it is going to full disk.

What to do...

OK.

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

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

Can you explain about that..

I executed the procedure, but i didn't get any information...

Thanks..

we are not configure max server memory ...

suppose if i want configure max server memory setting for 16 GB Ram... what is size will give...

It is blocking.. for insert and update operation..

It is happening 3 days, because PLP review for employee, so that more than 600 users connected insert and updating data at same time...

Sp_who

two procedure we found...

this profile had working last year 2012 27th, then outlook migrated cloud , after that we are getting error..

before that, notification is working fine.

performanace...

It is not working..

yes, correct, it is corrupted of MSDB , what will do repair MSDB for sql server 2000, we dont have backup ..

Thanks for your correct found the issue.

What is this error?

SQLServer Error: 3908, Could not run BEGIN TRANSACTION in database 'msdb' because the database is in bypass recovery mode. [SQLSTATE 25000] (ConnIsLoginSysAdmin)

running under generic domain account, it has sysadmin role..

SQLServer Error: 3908, Could not run BEGIN TRANSACTION in database 'msdb' because the database is in bypass recovery mode. [SQLSTATE 25000] (ConnIsLoginSysAdmin)

2012-11-12 17:40:51 - ! [298] SQLServer Error: 3621, The...

Please can you give proper inputs for that/