Hi,
Does anyone know if the Business Intelligence Development Studio (BIDS) that comes with SQL 2005 has a memory leak or a service pack that might address a memory leak?
When I'm trying to render previews for a report, my CPU is 100% consumed. I have 1 GB Ram and a Pentium 4 3.6 GHz CPU. Is there perhaps a setting within the BIDS environment that I can changes so as not to utilize all of my CPU or to release it after a certain amount of time?
Thanks in advance for advice and/or help about what to do in order to be able to use BIDS.
Kind Regards,
Barbara
Hi Barbarabarry,
As per BOL Sql Server's memory architecture is dynamic,it consump all avialable memory it can and released as an when required and requested by another resources. However SQL Server Express CTP SP2 released you may obtain it from http://www.microsoft.com/sql/ctp.mspx CPU consumption generally depends upon complex query and resource intensive reports does your report contain any complex calulations!!!!
Refer http://msdn2.microsoft.com/en-us/library/ms187499.aspx for more on Memory Architecture of SQL Server .
Hemantgiri S. Goswami
No comments:
Post a Comment