General

Object snapshots are not used when calculating statuses.

ST#44017

SC#723645-1

Server tree and the Overview report show Critical status if Fragmentation today is critical.

ST#44261

If there are many disk drives, the PDF files display the instance-level charts incorrectly.

ST#42512

SC#663993-1

Middleware

The Middleware installation wizard cannot identify install errors during a remote installation.

ST#43249

'Out of memory' exception occurs due to memory leaks after the middleware generates more than 50Mb reports (utilizes ~1Gb of memory).

ST#43592

'Object reference' error occurs when loading Mount Points from the Instance Overview tab.

ST#43843

SC#720221-1

Send report feature should be optimized to work correctly when there are a great many objects in databases.

ST#43047

SC#679871-1

Manage Fragmentation

If USE FAST OPTION is selected for SQL Server 2000, the Extents column should contain only n/a values.

ST#44596

SC#757806-1

SORT_IN_TEMDB should be used for index defragmentation and ONLINE rebuild operations.

ST#43956

SC#721924-1

Provide an option to switch databases from full to bulk logging and back after index reorganization is finished.

ST#44129

It is impossible to run several Intelligent Defragmentation Jobs at the same time.

ST#43835

Defragmentation queue is calculated incorrectly, if a new fragmentation snapshot was collected only for one server from group.

ST#43952

SC#722443-1

Defragmentation queue calculation is incorrect, because all the estimated duration values are '00:00:00', regardless of index size.

ST#43905

SC#722443-1:

dm_db_index_physical_stats is used with LIMITED option when only DMV is selected; and with SAMPLED when DMV and FAST are selected.

ST#44703

Spotlight

Incorrect Spotlight Statistic Data view in Capacity Manager if non-default port is used in the Spotlight.

ST#43783

SC#693175-1

Capacity Planner

Time Series in Consolidation Summary report

If there are a lot of databases that are consolidated and Time Series is used as a forecast algorithm, the Consolidation Summary report may take a long time to load.

Unable to create Consolidation project in Offline mode

Workaround:

1. Create Consolidation project in Online mode

2. Switch to Offline mode

ST#41911

ST#42279

Forecasting

Forecasting is not supported when the time period between snapshots is less than one minute.

Time Series algorithm

If you use the Time Series forecast algorithm but there are a few collected data, forecasting charts may show invalid forecasts.

ST#41991

64-bit Platforms Support

Creation of a collect data job fails for x64 SQL Server instances

If the repository is installed on a x32 SQL Server 2000 instance, the creation of a collect data job fails for x64 SQL Server instances with the following exception message: "OLE DB provider 'SQLOLEDB' reported an error.

[OLE/DB provider returned message: Unspecified error] [OLE/DB provider returned message: The stored procedure required to complete this operation could not be found on the server (they were supplied with the ODBC setup disk for the SQL Server driver).  Please contact your system administrator.] OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRowset returned 0x80004005"

Workaround:

1. Download the instcat.sql script from the Microsoft support site.

2. Execute this script on the SQL Server instance where the repository resides.

SC#516198-1

Limited support of SQL Server Aliases

When you define a SQL Server for the Capacity Manager Repository with the Create/Select Repository Wizard, you can use either the name of the SQL Server or its alias. If you use an alias, you must also configure all monitored instances to use the same alias for the SQL Server instance where the repository resides.

Otherwise, the Collect Data wizard fails with an error that the SQL Server does not exist or access was denied.

SQL Server Agent stop is not detected

Capacity Manager cannot detect when a SQL Server Agent stops if the Agent XPs option for the SQL Server 2005 is disabled.

Workaround:

To enable the Agent XPs option, run the following SQL script:

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'Agent XPs', 1;

GO

RECONFIGURE

GO

See the Microsoft documentation at:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/2e1c6c64-5ce7-4357-98c7-ac7763a9f9de.htm for details.

ST#32092

Status Calculation

Statuses displayed in the tree view and in the Fragmentation Today page may differ from the Fragmentation Management report. Manage Fragmentation list is based on last instance or database fragmentation snapshot or object fragmentation snapshot generated after the Intel Defragmentation or Indexes Reorganization jobs complete. Statuses Calculation uses only instance or database fragmentation snapshots information and does not use the latest object fragmentation snapshots.

Workaround:

If you use the Intelligent Defragmentation job, schedule the Collect Data job to collect instance and database fragmentation snapshots after the Intelligent Defragmentation job is executed and before you start or schedule statuses calculation.

Status Calculation

Capacity Manager calculates statuses from capacity, fragmentation, and performance data on monitored instances and databases. If you collect capacity information for databases only and do not collect capacity information on instances, Capacity Manager does not take into account capacity threshold settings when calculating statuses. You need to collect capacity information at the instance level to include capacity thresholds settings in the status calculation process.

Job Schedule

Job schedule is an object in SQL Server. It has the Enabled property. The console does not check or change the Enabled status for the Job schedule. If it is disabled manually in Management Studio, the Collect Data job does not execute.

Collations

There are different collations on monitored instances and the repository instance. There are some problems with a SQL Server OPENDATASOURCE connection from SQL Server 2000 with European collations to SQL Server 2005 with Asian and Arabian collations (i.e., Azeri_Latin_90_CI_AS, Chinese_Hong_Kong_Stroke_90_CS_AS).

The error is:

The OLE DB provider 'SQLOLEDB' provided invalid collation. LCID = 0x2c040000, Compflags= 0x01000300, SortId = 0x0.

OLE DB error trace [Non-interface error: OLE DB provider provided invalid collation:LCID =0x2c040000, Compflags = 0x01000300, SortId = 0x0, fLuxor = TRUE.]

Workaround:

Use two SQL Server 2005 servers in this case. This error occurs only when you connect from SQL Server 2000 to SQL Server 2005.

Permissions

To view Database reports, you must have at least db_owner rights. But to view information about a particular object in the database, you may have just db_reader rights. To view Instance reports, you must have 'sa' rights.

Relocate Objects Wizard

You need sa rights on the server to run the Relocate Objects wizard.

Relocation of LOB data is not supported.

Offline operation mode

In Offline mode, the console does not support local servers registered with short names like: <local\inst1> or <.\inst1>.

ST#0190886

Empty databases without objects could have different used log size

DBCC SQLPERF (LOGSPACE) is used in the collect data process. DBCC SQLPERF (LOGSPACE) for empty databases returns different values for the used log size. There is no information available from Microsoft regarding this issue.

Send Report

Collaboration Data Objects for the Windows 2000 (CDOSYS) message component is required for sending email.

Read more about CDO object

CDOSYS was first available in the Windows 2000 Server. As of December 2003, CDOSYS is an integral part of the Windows 2000, Windows XP, and Windows 2003 operating systems.

• SendReport does not support local servers registered with short names like: <local\inst1> or <.\inst1>.

• The Time Series forecasting algorithm is not supported for Send Report. The Linear algorithm is used instead.

• If you do not have reports to send (excluding the Server Group Report) and you follow a user who has object reports in the Report Schedule Options list, you get all the reports selected for the previous user.
   

Workaround:

Add any object report to your account or put your name in the Recipients List in Report Schedule Options.

ST#0180890

ROI Calculator

If the database size is decreasing, the forecast for the next 6 months can be equal or less than zero.

If the forecasted database size is less than the current database space used size, the recommended size is set to the current database space used value of +10%.

Object Search

Capacity Manager does not display imported instances in the Search Criteria window of the Find Objects tool.

ST#40904

Database Mail

Database Mail notification is not supported for the following wizards:

• Create Partitioned Table

• Create Partitioned Index

• Alter Partitioned Table

• Alter Partitioned Index

• Make Table Unpartitioned

• Make Index Unpartitioned

ST#33722, 33640

Manage Capacity

Database Capacity | Database Overview box

Growth values are always calculated by the Minimum Squares rule using all snapshots loaded into the console. The calculation does not depend on Option settings.

Server Capacity | Instance Overview and Databases Capacity

Growth values are always calculated by the Minimum Squares rule using all snapshots loaded into the console. The calculation does not depend on Option settings.

Shrink Database Wizard

Some online databases do not appear in the list of objects for shrinking.

ST#0176924

Database Profiles

Capacity Manager cannot view a database profile if the database contains objects with identical names but different owners.

ST#40828

Manage Fragmentation

Database Map: Scan Density and Fragmentation Maps

Database Map does not support the correct representation for objects with the same name located in different schemas.

Empty Database Fragmentation

Fragmentation charts for an empty database (without user objects) are always empty and fragmentation snapshots display a Fail state. This is a result of executing the DBCC SHOWCONTIG command.

Fragmentation snapshots are not collected for empty (without data) Indexes and Tables.

At the Console, an error stating that all fragmentation charts for those objects are empty and you need at least 2 snapshots displays if indexes and tables do not contain data.

ST#0164687

Defragmentation queue

Default timeout can be insufficient for defragmentation queue calculation (default timeout is 30 minutes).

Workaround:

1. Reorganize repository database indexes.

2. (Optional) Manually set the QueryTimeout value within the registry (HKEY_LOCAL_MACHINE\SOFTWARE\QUEST SOFTWARE\Capacity Manager) on the machine where the console is installed.

3. Run defragmentation queue calculation.

ST#44130

Intelligent Defragmentation

Capacity Manager uses the instances and databases which you select for automatic defragmentation to limit the number of objects you can select manually.

Capacity Manager analyzes and reorganizes only those objects for which there are snapshots in the repository.

Manage Partitions

Create Partitioned Index wizard

When you select a column with an improper type for the partition key, the Next button is disabled but no message displays.

Create Partitioned Index wizard

Only unpartitioned objects display in the tree on the Alignment step.

Sliding Windows Scenario and Switch Partition wizards

If a table contains a column with 'character' in its name and you create a new table, an error message displays after script generation and you cannot proceed through the wizard.

Non-partitioned tables

A switch operation from a non-partitioned to a partitioned table is not supported.

SQL Server 2005 - partition non-partitioned tables

In SQL Server 2005, any non-partitioned table is considered a partitioned table with a single partition. Capacity Manager collects information for this single partition. If you split the table, SQL Server 2005 considers new partitions unrelated to the initial partitions. Capacity Manager considers one of the new partitions as an initial partition. Partition Disk Capacity and Partition Fragmentation reports for one of the new partitions display information for the initial partition.

Workaround:

Create a new snapshot of the partitioned table to update information in the repository. Manage Partitions displays the correct reports for the new partitions.

ST#31860

SQL Server 2005 - re-partition a table

If data collection appears before and after re-partitioning of a table, information in Partitions Disk Capacity and Partitions Fragmentation reports refers to the previous partitions. For example, if you collect data about a partitioned table, unpartition the table and create new partitions, Manage Partitions considers the new partitions to be similar to the original partitions.

Workaround:

Create a new snapshot of the partitioned table to update information in the repository. Manage Partitions displays the correct reports for the new partitions.

ST#34476

Collect Data

When you have more than 800 000 partitions per database the collect data job can take up to 8 hours to execute.

Workaround:

Run the Collect Data wizard. On the Collect Capacity Data pane click Advanced and clear the Monitor partitions separately... checkbox.

ST#42953

SC#683450-1

Manage SharePoint Capacity

Delete SharePoint registration

Deleting the SharePoint registration from the tree view does not delete data about SharePoint from the repository.

ST#37688

Monitored Server

Change servers computer name

When you change the computer name, you also have to rename the instance.

If you are running SQL Server 7.0, after renaming the SQL Server machine, the SQL Server service fails to start with the following error message "Your installation was corrupted or has been tampered with.

Workaround:

Re-run the SQL Server set up. After upgrading, the necessary SQL Server registry entries are reset with the new computer name and you can start the SQL Server. After restarting, use Toad or Query Analyzer to run the following commands:

EXEC sp_dropserver 'Your_OLD_Computer_Name'

GO

EXEC sp_addserver 'Your_NEW_Computer_Name', 'local'

GO

Restart your SQL Server service. Connect using Toad or Query Analyzer and run the following command (it should output the new server name):

SELECT @@SERVERNAME

GO

If you are running SQL Server 2000, the new name is recognized the next time SQL Server service starts. You do not have to re-run the setup. However, you have to run the sp_dropserver and sp_addserver stored procedure as shown above.

Manage Jobs

The Console stops responding if you try to load an old job with a large job history.

For example, the Console stops responding if you try to view the jobs for an instance when one of the jobs was created more than a year ago and is executed on an hourly basis.

ST#40926

Jobs

Job schedule

If the collect data job schedule has been changed (e.g. renamed) by an external application, it won’t be recognized by the Collect data wizard and new default schedule will be created.

Workaround:

Proceed to the Capacity Data step using the Collect data wizard. To alter job schedule click Browse, then Change.

Jobs fail to start

SQL Server Agent jobs have an owner field. If the owner account does not have rights to log into SQL Server, all jobs created by the owner fail to start.

Possible use case:

The system administrator with account DOMAIN1\User1 was created to run collect data jobs at several monitored SQL Server instances. After some period of time, the owner left the company and the system administrator disabled the DOMAIN1\User1 account. After the first restart of SQL Server instances, all jobs created by the that administrator fail to start. In this case, the jobs owner account should be changed to another account which has access to SQL Server.

Middleware Service

Installation

Remote middleware installation fails when the UAC option is enabled for Vista or 2008 Server.

Workaround:

Select the Save configuration (manual installation) option on the Installation Type pane of the Middleware Installation Wizard.

ST#43594