Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Service Broker Issues - SQL 2005 Enterprise Edition 64 SP3 Expand / Collapse
Author
Message
Posted Tuesday, April 16, 2013 6:38 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 10:02 AM
Points: 68, Visits: 336
Hello,

Before to start I just resume actions I made to reduce msdb size (earn space on c: volume).

I checked my msdb and I has a sysxmitqueue table using 3 Gb. I purged table by using the following commands :

ALTER DATABASE [msdb] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE [msdb] SET NEW_BROKER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE [msdb] SET MULTI_USER
GO

After that I shrinked msdb database and reorganized Index with Stat. Well every worked fine but now some Alerts defined don't work like "Capture deadlock" or "Capture Process blocked" (WMI Events).

I run some scripts

select * from msdb.sys.server_event_notifications

The result is : one line with SQLWEP_RECHECK_SUBSCRIPTIONS before Purge sysxmitqueue I had
Post #1442710
Posted Tuesday, April 16, 2013 7:39 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:23 PM
Points: 13,272, Visits: 12,103
Duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1442713-149-1.aspx

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1442739
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse