VMWare Memory Issue with Heavy SQL Server queries
Posted on 2009-07-10
Scenario: We have 2 guest systems one is a file sharing server, and the other is a SQL server. Both systems, have memory allocated, and are attached to a SAN.
Problem: We are running intense queries to this SQL Server also we are importing information from files that are located on the File Server into a SQL database that is located on another ESX server.
What we are seeing is the file that we are trying to import into our SQL database *(SQL Server is located on a Different ESX Server).
Is getting Information injected from the intense query.
NOTE: The only file with the injected information is the one that is being loaded into memory.
If we reboot the File Server we can go back and check the file in question and see that the file will no longer have the injected information.
We can also stop all queries and imports and only execute the queries. Once the memory block, for which the file that has the injected information gets over written, we can then open the file in question and see that the injected information will no longer be there.
Has anyone seen this before any help would be great?