Welcome to Port3101.org : Your BES Connection Mark forums read | View Forum Leaders
Port3101.org : Your BES Connection



Reply
LinkBack Thread Tools Display Modes
KB04484 - What is the MSDE Workload Governor?
 
  #1 (permalink)  
Old 09-20-2009, 04:35 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default KB04484 - What is the MSDE Workload Governor?

KB04484 - What is the MSDE Workload Governor?


Environment

  • BlackBerry® Enterprise Server version 4.0 to 5.0
  • Microsoft® SQL Server® Desktop Engine 2000 (MSDE 2000)



Overview

MSDE 2000 has specific limitations compared to the full version of Microsoft® SQL Server® 2000. One of the key limitations that affects the BlackBerry Enterprise Server is the workload governor.
The workload governor is automatically invoked when more than 8 operations or transactions are requested of the MSDE at the same time. The workload governor will then slow down performance of the MSDE by pausing for a few milliseconds before processing the next operation.
The workload governor is implemented at the Microsoft SQL Server instance level and not at the database level. If more than one database shares the same MSDE instance and if the total number of operations of all databases exceeds 8, then the workload governor is invoked for the MSDE instance.
As the number of BlackBerry smartphone user accounts increase on the BlackBerry Enterprise Server, the number of calls to the database will also increase. When this occurs, the workload governor is invoked more often causing degradation in performance of the BlackBerry Enterprise Server. To determine if the workload governor has been invoked, see KB11313.
The number of connections that can be made to the MSDE is not limited by the workload governor. As with all versions of Microsoft SQL Server 2000 (Standard and MSDE) the total number of connections that can be made to the Microsoft SQL Server is 32,767. As the number of connections increases, the likelihood of the workload governor being activated will also increase.
For more information on the Microsoft SQL Server 2000 workload governor, visit the Microsoft SQL Server Developer Center site and search for "The SQL Server 2000 Workload Governor". For further information, you can also visit the Microsoft® Website and search for “MSDE Workload Governor.”
For information on how the workload governor works with the BlackBerry Enterprise Server for IBM® Lotus® Domino®, see the Performance Characteristics: BlackBerry Enterprise Server Version 4.0 for IBM Lotus Domino white paper.
Note: The workload governor has been removed from Microsoft® SQL Server® 2005 Express Edition.
For a complete list of differences between the MSDE 2000 and Microsoft SQL Server 2005 Express Edition, visit the Microsoft SQL Server Developer Center web site and search for "Microsoft SQL Server 2005".
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
Sponsored Links
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In Place upgrade from MSDE to SQL 2005 Express dguillaume Port 3101: The BES Admin Bar & Grill 1 07-05-2011 04:32 PM
KB11313 - How to determine if the workload governor in MSDE has been exceeded hdawg Featured BlackBerry KB Articles 0 09-20-2009 04:35 PM
KB04147 - Run BES with local MSDE and remote BlackBerry Manager hdawg Featured BlackBerry KB Articles 0 06-14-2009 08:41 PM
KB11232 - Cannot install a named MSDE instance for BES 4.1 hdawg Featured BlackBerry KB Articles 0 04-01-2009 02:43 PM
KB11232 - Cannot install a named MSDE instance for BlackBerry Enterprise Server 4.1 hdawg Featured BlackBerry KB Articles 0 01-10-2009 01:57 PM


All times are GMT -4. The time now is 05:46 AM.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2018, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2