And you're seeing exactly why PLE is a horrible measure, standing on it's own. In combination with other measures, it may tell you things. Just PLE, nope. No real...

I would start by down loading Glenn Berry s diagnostic queries and running these.

With page life expectancy, look at the long term trend. See Jonathan Kehayias blog about it...

Sorry I am not sure what you are asking. The case statement you show has two options - 'replicated' or 'not replicated' so I don't understand when you would...

I cannot see how <blocking-process> stands on the way of <blocked-process>.

Both queries apply shared locks, so, they should not block each other.

Can you find what is waitresource in the...

I cannot see how <blocking-process> stands on the way of <blocked-process>.

Both queries apply shared locks, so, they should not block each other.

Can you find what is waitresource in the...

Yes Grant that what we found when ran the profiler trace many transaction with same spid but after...

• This reply was modified 5 years, 1 month ago by VastSQL.

You've identified some queries, but now you need to investigate their behavior within the system. The way to do this is to look at the execution plan in order...

Can you explain "We have 3 node in which 2 are SQL Cluster and 3rd one is Always On AG".?

But let's assume  you have a 3 node AwalysON AG,...

can you try creating two server with SQL 2019 in same windows cluster add them to AOAG. Create replicas in new servers and failover to SQL 2019 and then remove...

Thanks Grant .. Can you suggest any tool to reduce the RTO?

The exact reason is the BC team want to reduce the RTO from 100 minutes we mentioned...

Used Symantec / Backup Exec, then switched to Avamar Backup. But I only use native backup on sql server side; once the backup is done, backup team can back...

I'm not aware of this tool, so no real comment on it one way or the other.

However, the rules for any 3rd party solution for backups are very simple....

Never heard of it but from a quick google it seems its another DELL EMC product.

We did have Data Domain at one place I worked another DELL EMC product...

Hi Experts,

Currently we are using SQL Server and Database Mail to send reports and with new projects and requirements it seems like the Report sending will increase ....

• This reply was modified 5 years, 7 months ago by VastSQL.

SSRS is fairly solid for this

you can subscribe to reports (and get them emailed to you) and keep historic versions on the server... plus you can export in excel,...