We upgrade from MSSQL 2008 Standard to MSSQL 2014 to take advantage of the BPE on SSD. We have the database running on a Virtual Machine in Azure. For most databases, the performance is great, however for databases with a few large tables the performance is horrible.
Has anyone experienced anything similar? I've been looking around for solutions and cannot find anything.
The resources on the server seem to be fine....low CPU usage, etc.