Interim Update:

MS confirmed it was a most likely a bug most probably introduced around 6th Dec build (azure db) related to dropped rowset clean-up logic heading to dropped rowsets accumulating...

yeah, that returns the same information.

Thanks Kev,

All those have type=1 (in-row data). There is no columnstore index or lob data in the database. Is there a possibility that ADR is not removing allocation units after...

Thanks DesNorton,

Inner join will give me ~40 odd GB used by various table. The intent is to find allocation units that are not part of actual usage hence the left...

Here are more details. Looks like LOB data is the culprit..

LOB allocation for one of the tables has grown to 4200 GB. Going to ask app guys what have they...

I'm the DBA. We have...

Do you have a message broker running? Have the messages stopped being consumed?

The query below might shed some light on it for you:

 SELECT sch.[name], obj.[name],...

I ran your query sometimes back and its still running (1 hr 15 mins+), waiting for the output. Service broker is not enabled.

I ran another query (below) and I see...

• This reply was modified 3 years, 8 months ago by ps..

Thanks Steve.

TCP port was enabled. I added rule for UDP 1434 and it worked like a charm.

Thank you!

Thanks Jasona. Recovery model was full and i changed it to simple. Also, truncate as i mentioned in previous reply wasnt the solution. The problem started repeating after sometime. Then...

Some further updates:

.net process is something like this:

1. begin tran

2. delete from table

3. bulk import access file

4. commit

Since the process was failing mid way due to file size exceeding 10...

I tried importing the access file (49 MB) on both new (sql server 2016 express) and old servers(sql server 2081 R2 Express). New server's data file size increases from 1...

Thanks Lowell. The table is a clustered one. Data from this table is removed and fresh data is imported everytime. There is just problem that i see so far. Developers...

Update:

The actual problem is "Grand Total" is incorrect. This is true even when I do not select any dimension and just the sum of revenue.

However, when I slice it...

You definately need an expert to setup DR between the servers/sites.

You can have 2-node cluster (Standard edition of sql server supports) at both the sites and they can be mirrored.

Google...