Jeff Moden (12/22/2016)

but the only time I truly concern myself with a vertical drop with PLE is if it drops and stays there for an uncomfortable period of time. ...

I would agree if that was a small drop, for example from 3000 to 2000 sec. But a drop from 3000 to 100 sec I understand that some enormous process...

I also tried this, but within each timeslice there are dozens of processes, and how can I identify the culprit?

Thanks, I think I found it. There are 4 entries "Kernel-Boot" in Source, all with same timestamp (without milliseconds). One of them has "The last shutdown's success status was true....

No, I don't need to restore transaction log, we just bounced the server and that was all.

I need to find a point in time since when the users were stopped...

Thanks!

It works for me as well.

declare @var1 varchar(max) = 'It''s now or never I ain''t gonna live forever'

select len(@var1)-len(replace(@var1,' ','')) + 1

Yes, this is what I am doing now, thank you. And this job is scheduled to run only at weekend.

Thanks Gail, now I can easily run checkdb against this snapshot (regardless whether other connections connected to it or not), and I expect it to run for hours.

And thanks Jacob,...

Yes, I manually created it, with a script like this:

create database my_db_ss on

(name = my_db, filename = '.....ss'),

... 22 ss files ...

as snapshot of my_db

Checkdb fails in both prod and...

Thanks Scott, this is good DBCC command, I never knew about it.

dbi_dbccLastKnownGood = 2016-07-10 02:07:23.070

Checkdb is running only at the weekends. And our scheduling software (it's not SQL Server agent) keeps history only for last month. Within this month there was not a single...

And about an error log, there are only 2 records around that time indicating that the database was set to single- than to multi-user. But these were my tests that...

Here are all the messages:

Msg 5030, Level 16, State 12, Line 1

The database could not be exclusively locked to perform the operation.

Msg 7926, Level 16, State 1, Line 1

Check statement...

But what the reason of rebuilding all indexes?