SQL Server Slow After VM and SQL Restore

SQL Server 2016 SP2 Standard Edition
4 sockets with 6 cores per socket totaling 24 cores
128 GB RAM
Windows Server 2012 R2 Data Center

So, we had an incident about a month or so ago that required us to restore the VM and SQL on top of it. We use a Cloud Provider that does host some major companies across the globe, so it’s not a Mom and Pop shop.

So, the cloud provider had to perform what they called a BMR (Bare Metal Restore) of the VM from the last image taken, which was only a couple days old. This restored the OS and SQL Server Install, etc… Then, they recreated the Disk Mounts that were attached to the VM and restored the files, folders and permissions with a file level restore—not database files.

Once they were finished with this, we used our latest SQL Server backups and restored all the system databases first, then all the user databases. We confirmed all SQL Server settings were the same as before the Incident such MAXDOP, CTFP, Max Memory, Users and Server level roles/permissions, sql agent jobs, etc… and all were identical. When the VM was first brought up, I noticed they had 12 sockets with 2 cores each, so I had them change to 4 sockets with 6 cores each, as the Standard licensing got me many years ago and its the first thing I check when taking a VM.

We immediately noticed a lot of latency with the queries and SQL Agent jobs that run on this box, which was across the board and not just one query or job…all were running twice as long. WOrking with the cloud provider asking them to confirm the VM config was identical from old to new VM, they found a few things and fixed them.

We’re now at the point where everything is running maybe 60 to 70% as fast as it used to across the board and are at a stale mate it seems. Simple queries are trying to go parallel and when they do, they run exponentially longer…one example query, ran for 10 seconds and when we dropped the maxdop from 8 down to 4, less than 1 second…and MAXDOP of 7, 6 or 5 also yielded the 10 second run time and only when we got down to 4 did it go seral and fly. We are noticing out of the 24 cores, it seems that only 8 of them are every really ever being used by SQL Server. We told our cloud provider about the excessive CX waits and they just came back and said we were on a Tier 1 storage before and we are now on Tier 2 because the previous Tier was mislabeled or something. Tier 2 has an expected latency of <=20ms while Tier 1 has an expected latency of <=10ms.

Anyways, does anyone really think that the storage could be trickling down and causing the excessive CX waits? We’ve asked for the Phsyical NUMA config on the old VM several times and havent gotten an answer yet and the new VM only seems to have the default (1). SQL Server created 3 Soft NUMA nodes, so was wondering if anyone else thought Physical NUMA would be a more likely culprit?

Again, only thing different is VM and possibly tiered disk storage…SQL Server was restored with all same setting and all same queries are all running twice as long if not longer. Unfortunately, we dont have visibility into the VM config or VMWare Tools or anything, so are asking for a side by side comparison be done.

sharepoint online – How to restore All Documents View

With SharePoint Online, is there a way, within a SharePoint site, that a Site Collection Administrator can restore columns for an “All Documents” view if they have been dynamically changed?

In my case they were because I used the SharePoint migration tool to bring over some data from SharePoint 2013, back to OneDrive (SharePoint Online behind the scenes). As a result my OneDrive column headers are different and represent headers from some files from SharePoint 2013.

I’m so frustrated because I had no idea that a SharePoint migration would jack up columns in the “All Documents” view, that powers OneDrive.

So my question, is there a way to restore/reset the All Documents view if its been dynamically modified?

bitcoincore development – c++ code how to restore wallet keys from mnemonic seed phrase

so iam trying to code some wallet functions in c++ i need to do the following.

  1. starting with a seed phrase
  2. restore the private keys and bitcoin addresses (all addresses generated from the seed phrase) I understand you can deterministically generate private keys and their corresponding public keys (bit coin addresses)
  3. check the balances on those addresses

which of the c++ or (java) libraries can I use and how to i get this going?
I have tried using java bitcoincore libraries but when i used my known seed the private keys and addresses generated where way off.

How do I restore the public key?

Let say, I create wallet and have two public key and one private key.

And I remove the first public key from the wallet.

Can I restore and use my first key again? Or it’s removed at all.

How Restore backup as overwrite on a database in use in SQL Server?

I Want to restore a backup with overwriting on a database in use
for this problem I want to create a query base on these steps :

1- Remove All Connections [MyDB]

2- Create a backup from [MyDB]

3- Restore a Backup as an Overwrite on [MyDB] from specifying a path

Thank you very much for your help

Can I restore my SQL Server database to a point before the last full backup with my current backup strategy?

If I have this backup strategy(weekly full backup and 1 hour log backup), can I restore the database to the green highlighted period of time? Btw, does log backup 2 includes all log records that have their lsn great than the last_lsn of log backup 1?

enter image description here

finder – How to restore files from time machine backup (on Apple Time Capsule) of a different computer?

I need to find some files located in a time machine backup of an old computer. It’s a backup located on an Apple Time Capsule.

As it’s used as my router, I’ve tried going to Finder, then clicking on the Time Capsule under locations, entering the password and connecting. Then there’s a folder called ‘Data’. Within it there is the backup for the old computer in .dmg file format. From other things I’ve read, when it’s a backup on an external drive there should just be a folder you can click in to, to look at files. That’s not the case here when it’s on a time capsule. If you ‘show package contents’ of the .dmg there’s nothing usable or viewable, just lots of exec files.

I’ve also tried go to time machine in the menu bar and press alt, ‘browse other backup disks’ but that doesn’t seem to work and just shows me a today finder window for my finder.

It would be great if someone knows what to do here. Thanks

How can I restore my USB storage on my Android phone?

I have a Samsung A50 Android phone. I am getting message that USB storage has been removed restart your phone. So I do that and nothing happens. I still get the error message. How can I fix this?

php – Script that will auto restore cPanel/Directadmin backup (no SSH or WHM)

Most of us probably restored cPanel/wordpress backup manually on new hosting account. As described here: https://www.namecheap.com/support/knowledgebase/article.aspx/9364/2199/how-to-restore-cpanel-backups-for-addon-domains-partial-cpanel-transfer/ (Ignore the addon part)

I was wondering, is there a script that will wget the backup from origin server and will automate all the manual tasks: Unzipping, Restoring DB (db name and pass will be given to script), Editing wp-config file

I know about duplicator and updraftplus, But they require you to install plugin on origin server

Script that will auto restore cPanel/Directadmin backup (no SSH or WHM)

Most of us probably restored cPanel/wordpress backup manually on new hosting account. As described here: [url]https://www.namecheap.com/supp… | Read the rest of https://www.webhostingtalk.com/showthread.php?t=1843221&goto=newpost