Ah, if literally the only difference is the AG, then it is likely you're just running into the problem of REDO on the secondary falling very behind during the rebuilds....

There are a couple things I'd check.

First, is the DB using the Full recovery model in the test environment? If it's using Simple in the test environment, that would go...

Well, "backup devices" in general are just the physical media to which you backup your databases.

If you're referring to the logical backup devices you can define (like this), then no,...

It's not pretty, and I'm not sure why actually running continuously would be better than running every 10 minutes, but if you really wanted it to start a new run...

As Gail pointed out, the trigger will fire for every update.

You can control when it logs to your audit table, though, using the inserted and deleted tables like she said.

You're...

You could use INPUTBUFFER to grab the outermost level of code executing for that SPID.

Something like this (you'd obviously have to change the specific table information, and you might want...

Lowell (7/8/2015)

---

Ray check out this script from my friend Gianluca Sartori; he's posted it several times here on SSC;

he basically takes advantage of how DBCC supports WITH TABLERESULTS, and stuffs...

Ah, that's the problem.

You're taking the principal_id of 'dbo' from database_principals, and passing it to the SUSER_NAME function, which will just return the name of the login from server_principals...

Joie's suggestion is the safest way, if you're planning on using this information to drop/offline a database. Just make sure to monitor the database for an appropriate period of time...

Just to explain what was at issue with the original script, check out this from the documentation of IS_SRVROLEMEMBER:

If a Windows login, such as Contoso\Mary5, is specified for login, IS_SRVROLEMEMBER...

I'd start by checking out Perry Whittle's excellent Stairway series on Always On here: http://www.sqlservercentral.com/stairway/112556/

Cheers!

That query is just counting the number of pages SQL Server has cached in memory for each object's indexes. Having frequently accessed pages in memory is a good thing, since...

This is due to a funny behavior of DECLARE statements that has been leveraged for QotDs here several times, if my memory serves correctly.

Variable declarations occur at compile time, not...

That's because prior to 2012, ORDER BY clauses were not supported in aggregate window functions; they were supported only in ranking window functions.

See https://msdn.microsoft.com/en-us/library/ms189461(v=sql.105).aspx for the appropriate documentation.

Cheers!

I know it's an old thread, but since it's been revived today, Paul White discusses the internals of the various sorts used by SQL Server in these two fairly recent...