Blackberry PRD-10459-003 Administration Guide - Page 390

Microsoft SQL Server uses a considerable amount of disk space, Possible solution, Possible cause

Page 390 highlights

Administration Guide Troubleshooting: BlackBerry Enterprise Server Performance Once daily, the BlackBerry® Enterprise Server uses the BlackBerry Mailstore Service to refresh the user information from your organization's address book in the BlackBerry Configuration Database. If multiple BlackBerry Enterprise Server instances are associated with a BlackBerry Configuration Database, each BlackBerry Enterprise Server instance tries to use a BlackBerry Mailstore Service to refresh the address book information in the BlackBerry Configuration Database. The first BlackBerry Mailstore Service that starts the refresh process is responsible for completing it. If the BlackBerry Mailstore Service that is responsible for completing the refresh process is associated with a BlackBerry Enterprise Server that is geographically remote from the BlackBerry Configuration Database, the BlackBerry Mailstore Service can take an unexpected amount of time to complete the refresh process. The refresh process can use an unexpected amount of system resources and increase wireless network traffic. Possible solution You can use TraitTool.exe to turn off the address book refresh feature for BlackBerry Enterprise Server instances that are geographically remote from the BlackBerry Configuration Database. As a result, BlackBerry Enterprise Server instances that are located geographically close to the BlackBerry Configuration Database can use the BlackBerry Mailstore Service to refresh the user information from your organization's address book in the BlackBerry Configuration Database. TraitTool.exe is located in the Tools directory on the BlackBerry Enterprise Server installation media. 1. At the command prompt, navigate to the folder that TraitTool.exe is located in. 2. Type: TraitTool -host -trait MailstoreAddressRefreshEnabled -set False, where is the name of the BlackBerry Enterprise Server instance. 3. Press ENTER. To turn on the address book refresh feature for a BlackBerry Enterprise Server again, use the same command with a value of True. Microsoft SQL Server uses a considerable amount of disk space Possible cause Reorganizing or rebuilding an index in Microsoft® SQL Server® can cause the size of the transaction log file in the BlackBerry® Configuration Database to grow larger than expected. Possible solution Add the following tasks to the end of your organization's regular maintenance plan: 1. Perform a complete backup of the transaction log file. 2. Perform a shrink log file task on the transaction log file. 388

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252
  • 253
  • 254
  • 255
  • 256
  • 257
  • 258
  • 259
  • 260
  • 261
  • 262
  • 263
  • 264
  • 265
  • 266
  • 267
  • 268
  • 269
  • 270
  • 271
  • 272
  • 273
  • 274
  • 275
  • 276
  • 277
  • 278
  • 279
  • 280
  • 281
  • 282
  • 283
  • 284
  • 285
  • 286
  • 287
  • 288
  • 289
  • 290
  • 291
  • 292
  • 293
  • 294
  • 295
  • 296
  • 297
  • 298
  • 299
  • 300
  • 301
  • 302
  • 303
  • 304
  • 305
  • 306
  • 307
  • 308
  • 309
  • 310
  • 311
  • 312
  • 313
  • 314
  • 315
  • 316
  • 317
  • 318
  • 319
  • 320
  • 321
  • 322
  • 323
  • 324
  • 325
  • 326
  • 327
  • 328
  • 329
  • 330
  • 331
  • 332
  • 333
  • 334
  • 335
  • 336
  • 337
  • 338
  • 339
  • 340
  • 341
  • 342
  • 343
  • 344
  • 345
  • 346
  • 347
  • 348
  • 349
  • 350
  • 351
  • 352
  • 353
  • 354
  • 355
  • 356
  • 357
  • 358
  • 359
  • 360
  • 361
  • 362
  • 363
  • 364
  • 365
  • 366
  • 367
  • 368
  • 369
  • 370
  • 371
  • 372
  • 373
  • 374
  • 375
  • 376
  • 377
  • 378
  • 379
  • 380
  • 381
  • 382
  • 383
  • 384
  • 385
  • 386
  • 387
  • 388
  • 389
  • 390
  • 391
  • 392
  • 393
  • 394
  • 395
  • 396
  • 397
  • 398
  • 399
  • 400
  • 401
  • 402
  • 403
  • 404
  • 405
  • 406
  • 407
  • 408
  • 409
  • 410
  • 411
  • 412
  • 413
  • 414
  • 415
  • 416
  • 417
  • 418
  • 419
  • 420

Once daily, the BlackBerry® Enterprise Server uses the BlackBerry Mailstore Service to refresh the user information
from your organization's address book in the BlackBerry Configuration Database. If multiple BlackBerry Enterprise
Server instances are associated with a BlackBerry Configuration Database, each BlackBerry Enterprise Server instance
tries to use a BlackBerry Mailstore Service to refresh the address book information in the BlackBerry Configuration
Database. The first BlackBerry Mailstore Service that starts the refresh process is responsible for completing it.
If the BlackBerry Mailstore Service that is responsible for completing the refresh process is associated with a
BlackBerry Enterprise Server that is geographically remote from the BlackBerry Configuration Database, the
BlackBerry Mailstore Service can take an unexpected amount of time to complete the refresh process. The refresh
process can use an unexpected amount of system resources and increase wireless network traffic.
Possible solution
You can use TraitTool.exe to turn off the address book refresh feature for BlackBerry Enterprise Server instances that
are geographically remote from the BlackBerry Configuration Database. As a result, BlackBerry Enterprise Server
instances that are located geographically close to the BlackBerry Configuration Database can use the BlackBerry
Mailstore Service to refresh the user information from your organization's address book in the BlackBerry
Configuration Database.
TraitTool.exe is located in the Tools directory on the BlackBerry Enterprise Server installation media.
1.
At the command prompt, navigate to the folder that
TraitTool.exe
is located in.
2.
Type:
TraitTool -host
<name>
-trait MailstoreAddressRefreshEnabled -set False
, where
<name>
is the name
of the BlackBerry Enterprise Server instance.
3.
Press ENTER.
To turn on the address book refresh feature for a BlackBerry Enterprise Server again, use the same command with
a value of True.
Microsoft SQL Server uses a considerable amount of disk space
Possible cause
Reorganizing or rebuilding an index in Microsoft® SQL Server® can cause the size of the transaction log file in the
BlackBerry® Configuration Database to grow larger than expected.
Possible solution
Add the following tasks to the end of your organization's regular maintenance plan:
1.
Perform a complete backup of the transaction log file.
2.
Perform a shrink log file task on the transaction log file.
Administration Guide
Troubleshooting: BlackBerry Enterprise Server Performance
388