Call me the bad guy but I'd love to use AI for predictive maintenance, the drive will still fail I might just know about it in advance.

Have you checked the upgrade advisor? Not that it's extremely useful - it'll miss unused but deleted folders from the Installation which will lead to the upgrade failing - but...

I'm actually fascinated to see such recommendations at all, I've seen enough software which would alone by the expected volume of data (> 16 TB, eDiscovery) require more than one...

Have you tried applying SP3-CU2 at least? If that doesn't help open a support ticket with Microsoft. This error is related to spin-locks most likely.

well the thing is rebalancing of data is (I think) based on % space free in each Filegroup so if you have like 10 - 20 % free space inside...

• This reply was modified 5 years, 5 months ago by  DinoRS. Reason: clarification
• This reply was modified 5 years, 5 months ago by  DinoRS.

This sounds like all your users ended up in model database. Remove them from there and newly created db's shouldn't have those users added by default.

Well you could do as a first step get 2 more LUNs with 250 GB each and after redistribution of all data shrink the files on the first 2 LUNs...

I'll add https://www.pass.org/ to that list noting that it's not directly training as per MOC course or something but rather by topic which you can choose from.

Just wanted to make a note that Google already had to blur out houses and the likes in Germany before GDPR came into effect.

Or if you want to look at...

Browncoat42: for you being able to at least envision Data Warehouses with definite need for more than a to me "envisioned rule of thumb" you seem to apply.

Other than that, am I the only one that wonders why there is a seeming need from Microsoft for their default database location being in precisely the wrong...

Maybe it has something to do with LocalDB? Is it a true restore from MSSQL Backup or is it some sort of .mdf & .ldf File Restore?

First of all I would read up on PAGEIOLATCH_SH then you should come to the conclusion that PAGEIOLATCH_SH is a soft lock on a certain DB page.

Combined with your...

Ah, now I get it, we're going back to being the "one-stop-shop for MSSQL DBs" is called DevOps these days, fair enough. Nice article you wrote there 🙂

I agree with Jeff that the improvements of adaptive Flash storage (AFS?) and AFA (all-flash array) might be highly overrated, if the application design plain and simple sucks, what's your...