Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
markyannix
Starting Member
1 Post |
 Posted - 2009-03-18 : 02:27:26
|
| Hello,I am new to this site. I have been trying to research on problems on SQL and most of the solutions i tried came from here. So i am hoping that my SQL problem this time gets solved here.I have a full database back up and wanted to restore it to my local machine. I have SQL 2005 installed on my Dev box with QuadCore. The restored DB is about 3GB in size. Upon checking SELECT is_broker_enabled,* FROM sys.databases the is_broker_enabled is 0. The applications that i develop are using SQL's broker service. so i enable the service. MEM usage then goes up from 500MB to 1.6GB and slows down my box to a halt. How do i go about this. When broker service is disabled there is no problem. But i need the service activated but as a result it kills my box. Is there something wrong with the backup file. How do i check?Thank you. |
|
|
|
|
|
PC slows down when Broker service is enabled