Why not just use sp_WhoIsActive for that stuff?  It's free.

Like I said before, knowing which files are the most active won't tell you a thing about what your problems are...

My question would be... What do you expect to actually do with such information?  It qualifies which files are the busiest but not why or whether or not being so...

I can see why keeping SSMS and ADS separate, both in functionality and as an installation, would make sense at this point, because it's on-prem versus Azure.

However, I have...

Heh... NP.  At least it wasn't me for a change. 😀 😀 😀

As per my understanding, LOB data will also get stored inside the page. However , if the row data is exceeding 8000 bytes, then the data is stored off...

Same question from me.  As well as why are you still using an ntext data type?  That was deprecated with SQL...

Lordy... some designer needs a serious pork chop lesson on the first rule of the First Normal Form. <facepalm>.

The only way you're going to be able to fix this for...

You're also running 2008, which is more than a decade old and hasn't been supported for years.  I strongly recommend that you develop an upgrade plan.

Heh... what a lot of people consider to  be "branching out" is a bit...

Dunno but I'm thinking they might need another "ding" in multiple areas.  They gotten way to arrogant...

Let's hope they keep them separate forever and realize that not everyone is ever even going to go near Azure and that SSMS needs to be maintained.

You're welcome and thank you for the feedback.

Unless you have some form of auditing turned on or you have setup the SQL Server log setup to report all successful logins AND you've kept all rollover logs from...

Way too little information here.  From where do you want to deploy the SSIS package?

Unfortunately this doesn't work for me. I am following all the steps and the C# script is able to execute without error but it does not actually run the...