您的社区
知识库
我们和维基百科一样:
您看到的所有信息均可由任何登录用户自由编辑。 本网站由社区成员创建,同时也服务于社区成员。
访问社区 »
SQL Server
产品社区
立刻加入社区,与世界知名的IT专家交流,讨论当前趋势,帮助您创造产品,还有更多精彩内容不容错过!
立即加入 »

Capacity Manager for SQL Server

Capacity Planning & Capacity Management Simplified.

运用Quest Capacity Manager for SQL Server全面掌控磁盘空间、增长速度和数据库性能。 通过它的中央控制台,您可以全面了解整个数据库环境的容量情况。 您将获得包括针对合并项目的建议和指标在内的智能索引维护。 此外,它还通过简化图表分区来提高性能。 确保您的SQL Server数据库及其支持的应用程序获得最佳容量规划。

今日容量——查看磁盘容量,包括准确的挂载点数据集、索引碎片、系统性能和SharePoint容量。

容量规划器——轻松管理SQL Server合并项目。

通过维护窗口支持进行智能化碎片整理——使用碎片整理资料自动分析和整理数据库对象碎片。 设置碎片阈值和整理选项。 在维护期间安排重整工作。

分区管理——在易用型界面的图表中创建、更改和删除分区。 可在SQL Server 2005和2008版本中轻松管理已分区的图表。

作业能力——基于Spotlight® on SQL Server Enterprise的统计数据库中的历史数据,提供作业能力图表和统计(需安装Spotlight)。

碎片和填充因子管理——管理并监测组、实例或数据库中的碎片和填充因子的变化。 

SharePoint模块——运用图形化工具管理当前及未来对SharePoint内容数据库的需求。

PowerShell命令行界面——运用Windows PowerShell技术,无需启动Capacity Manager即可访问其控制台。

数据库配置—— 对应用程序使用的数据库对象分组,并在单张图表中显示增长情况。

Before installing Quest Capacity Manager for SQL Server, ensure your system meets the following minimum hardware and software requirements.

Hardware Requirements

Platform32-bit or 64-bit Pentium IV (Core Duo recommended) or compatible processor.
Disk SpaceMinimum 200MB of disk space required for a full installation, which includes up to 50MB of temporary setup files that are removed automatically when installation completes.
Memory

512 MB of RAM minimum. The memory required may vary based on the following:

  • Applications that are running on your system
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database
MonitorSVGA monitor, 1024 x 768 resolution, small fonts.
CD-ROMCD-ROM drive or Internet connection (required for installation only).
PrinterPrinter for printing graphs and reports (optional).

Software Requirements

Operating System

Microsoft Windows XP Professional SP3

Microsoft Windows XP Professional, 64-bit

Microsoft Windows 2000 Professional SP4

Microsoft Windows Server 2003 (32-bit and 64-bit) SP2

Microsoft Windows Vista (32-bit and 64-bit) SP1

Microsoft Windows Server 2008 (32-bit and 64-bit) SP2

Microsoft Windows 7 (32-bit and 64-bit)

.Net FrameworkMicrosoft .Net Framework 3.0
BrowserMicrosoft Internet Explorer 6.0 or later
Database Client

MDAC 2.8 (or higher) and SQL Server Native Client (Microsoft SQL Server 2000/2005 client software and Backward Compatibility Tools for SQL Server 2005 or 2008 contain all required components.)

PDF Viewer

Adobe Acrobat Reader 5.0 or later (for viewing the Guides)

Monitored Server and Repository

Microsoft SQL Server 2000 (32-bit or 64-bit) SP4

Microsoft SQL Server 2005 (32-bit or 64-bit) SP3 or later

Microsoft SQL Server 2008 (32-bit or 64-bit) SP1

Microsoft SQL Server 2008 R2 (32-bit or 64-bit)

Additional Software

SharePoint 2003, Office SharePoint Server 2007, or SharePoint Services 2.0 or 3.0 to use with the Manage SharePoint Capacity tool.

Spotlight on SQL Server Enterprise 3.0, 3.0.2, 6.0, 7.0 or 7.6 to use with the Performance Capacity tool.

Server-Specific Requirements

The following table shows the approximate repository growth and memory required for the Middleware to generate reports:

ServerSmallMediumLarge
Objects (tables, views, indexes, partitions)10 000100 000500 000
Number of indexes reorganized daily*<100500>500
Repository growth*   

Daily, MB

120260860

In 3 months, GB

0.40.82.6

In 6 months, GB

0.71.65.1

In 12 months, GB

1.53.110.2
Memory required for the Middleware*   

to generate instance-level reports, MB

50-8050-8070-100

to generate detailed reports, MB

90-140150-300200-600

* — if using recommended (built-in) Capacity Manager schedules