When the same query is executed on the new R820 however, it takes about 4 seconds. When we run the query on the 2950, it takes about 1-2 seconds for results. These queries are being executed locally from the server and the database is also local so, it is definitely not network related. I recently migrated MSSQL from the 2950 over to the R820 but noticed MSSQL queries are a lot slower on the new R820 machine. I have MSSQL Standard database that has been virtualized and is currently hosted on the 2950. Both Operating Systems are Windows Server 2012 R2 Standard 圆4 Bit. Both of these machines are set up as a Virtual Machine Host Running Hyper-V. I have a 10 year old Dell Poweredge 2950 that will be replaced with a Dell Poweredge R820.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |