Queues and Filegroups

Hi

We can create a queue on a filegroup for performance reasons however what about the sys.transmission_queue which could have messages backing up when the target is down.

What are your thoughts.

Cheers

Currently there is no way to change the filegroup of the sys.transmission_queue.

Traditionaly, all system tables are allocated on the primary filegroup. The sys.transmission_queue is a system table, the database cannot function w/o it. Allowing for it to be moved a user filegroup opens the door to lossing it if the filegroup is lost. Allowing sys.transmission_queue to partition itself across filegroups causes similar problems. But your concern is valid, that this is an example of a system table than can grow large and cause problems on the primary filegroup. You can use the Product Feedback to make a sugestion if you feel this is important. http://lab.msdn.microsoft.com/productfeedback/

Regards,
~ Remus

|||

Remus

Thanks.