I have been dealing with some performance issues with SCOM SP1 in a VMWare environment... In my configuration the installation is distributed in that I have 3rd party management packs installed on a seperate server. The base install is teh RMS including SQL 2005 std SP1.
Yes yes... I know you are not supposed to virtualize SQL... I am monitoring performance on my environment as I go. I guess you could say i asked for it!
Anyways, this server is being plagued in the form of network performance and that makes the equests queue up, then paging starts... You know the drill... For a few days, the issue of what appears to be network according to the performance metrics seems to come and go as it pleases. The server is utilizing alot of its limited bandwidth even during normal operation. OK I set the stage.
Here is the weirdness... The server has 8GB of RAM assigned to it. The configured and running memory on the SQL server is drumroll... 2147483647MB. Yup... 2.1 Exabytes!
Throttled that baby ro 4500MB and then to 2048MB and performance has seemingly improved tenfold... To be clear, the memory occupied by the sqlservr.exe process has been and still is consistently between 800MB and 880MB... SQL hoodoo...
Hopefully save some pain for some of you.
To those of you who do not believe it... Yes, this is running on VMWare!!!