February 28, 2012 at 11:53 pm
Hello,
recently one of the servers have been migrated to virtual server with same configuration.
now the performance is slightly slow particularly in reporting services.
will the virtual conversion causing the problem or the around 100 more reports has been added which has reduced the performance.
suggestion pls
Regards
Durai Nagarajan
February 29, 2012 at 12:33 am
Define slightly slow ? Have you benchmarked the performance before and after the migration.
Are you sure the configuration is the same.
In theory a virtual server ( btw which one are you using) allows you to take advantage of underutilized CPU and RAM already present on the hardware.
If you were already were utilizing the hardware then migrating to a virtual server doesn't really help.
February 29, 2012 at 3:17 am
we have already 3-4 virtual servers in same hardware. but it takes the load perfectly without too much delay.
Only Report upload and access configurations earlier was around 5 seconds now it is taking more than 10 seconds for each process.
i dont have access to windows, but server configuration was confirmed by Server team. i too slightly confirmed using SQL server properties(same no of processors and RAM).
Virtual server is in SAN and optical network fiber. hope this data helps.
Regards
Durai Nagarajan
February 29, 2012 at 4:00 am
February 29, 2012 at 5:45 am
32 bit ,no changes, hardware changes like disk size may be.
Regards
Durai Nagarajan
February 29, 2012 at 4:43 pm
durai nagarajan (2/29/2012)
same no of processors and RAM
how many cpus how much RAM?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 29, 2012 at 11:52 pm
March 1, 2012 at 4:07 am
hello,
2 CPU and 8 GB RAM.
AWE is not enabled currently, can i know what will it do?
Regards
Durai Nagarajan
March 2, 2012 at 8:43 am
AWE will allow the server to use more than the 32-bit limit of about 4GB. Is there a reason they installed 32-bit over 64-bit? With 64-bit, you wouldn't need to use AWE.
March 2, 2012 at 8:48 am
No special reasons.
can you elobrate what is the effects of AWE and is there any negative impact?.
will server restart or service restart is needed?.
i have rough idea as it will use the memorey between min and max already set.
Regards
Durai Nagarajan
March 2, 2012 at 9:00 am
Yes, the service will need to be restarted.
AWE from 2005 Books Online: http://msdn.microsoft.com/en-us/library/ms190673(v=sql.90).aspx
March 2, 2012 at 10:03 am
durai nagarajan (3/2/2012)
No special reasons.can you elobrate what is the effects of AWE and is there any negative impact?.
will server restart or service restart is needed?.
i have rough idea as it will use the memorey between min and max already set.
When applying AWE to a 32 bit server you have to apply the lock pages in memory local policy to, this requires a server restart.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply