Document ID: 281261
http://support.veritas.com/docs/281261
E-Mail this document to a colleague
http://support.veritas.com/docs/281261
E-Mail this document to a colleague
Support for SQL Server 2005 with Enterprise Vault (EV) products.
Details:
Symantec has identified the following issues when running Microsoft SQL 2005:
Customers upgrading from SQL 2000 to SQL 2005 are likely to observe an increase in CPU usage on the SQL Server when EV is running. In extreme cases, this CPU usage will severely impact the performance of that SQL server, and therefore the overall performance of EV.
Symantec recommends running the following two SQL commands against ALL EV, Compliance and Discovery databases, once the SQL version is upgraded to SQL 2005:
1. Rebuild all indexes once after migrating to 2005. Command:
2. Run UPDATE STATISTICS with full scan to eliminate out of date statistics. Command:
These commands are documented in the section "Best Practices for Managing Statistics" in the following Microsoft Knowledge Base article: http://www.microsoft.com/technet/prodtechnol/sql/2005/qrystats.mspx
Note: For large databases, this command can take some time to complete. On a Vault Store database with 50 million archived items, rebuilding indexes can take in excess of two hours on an average enterprise-size server (two processors, 4 Gb memory).
Symantec is pleased to announce the support of Microsoft
SQL 2005 with EV products.
EV products will run with databases stored on Microsoft SQL 2005 for the following versions:
EV products will run with databases stored on Microsoft SQL 2005 for the following versions:
- EV for Microsoft Exchange 5.0 SP6, 6.0 SP1 or later SP, 7.0 (all versions), 2007 (all versions), and 8.0 (all versions)
- EV File System Archiving 5.0 SP6, 6.0 SP1 or later SP, 7.0 (all versions), 2007 (all versions), and 8.0 (all versions)
- EV for Microsoft Sharepoint 5.0 SP6, 6.0 SP1 or later SP, 7.0 (all versions), 2007 (all versions), and 8.0 (all versions)
- EV SMTP Archiving 6.0 SP1 or later SP, 7.0 (all versions), 2007 (all versions), and 8.0 (all versions)
- EV for Lotus Domino 6.0 SP1 or later SP, 7.0 (all versions), 2007 (all versions), and 8.0 (all versions)
- EV Compliance Accelerator 5.1 SP4, 6.0 SP1 or later SP, 7.0 (all versions), 2007 (all versions), and 8.0 (all versions)
- EV Discovery Accelerator 5.0 SP4, 6.0 SP1 or later SP, 7.0 (all versions), 2007 (all versions), and 8.0 (all versions)
Symantec has identified the following issues when running Microsoft SQL 2005:
Customers upgrading from SQL 2000 to SQL 2005 are likely to observe an increase in CPU usage on the SQL Server when EV is running. In extreme cases, this CPU usage will severely impact the performance of that SQL server, and therefore the overall performance of EV.
Symantec recommends running the following two SQL commands against ALL EV, Compliance and Discovery databases, once the SQL version is upgraded to SQL 2005:
1. Rebuild all indexes once after migrating to 2005. Command:
Exec
sp_MSForEachtable 'ALTER INDEX ALL ON ? REBUILD;'
GO
2. Run UPDATE STATISTICS with full scan to eliminate out of date statistics. Command:
Exec
sp_MSForEachtable 'UPDATE STATISTICS ? WITH FULLSCAN'
GO
These commands are documented in the section "Best Practices for Managing Statistics" in the following Microsoft Knowledge Base article: http://www.microsoft.com/technet/prodtechnol/sql/2005/qrystats.mspx
Note: For large databases, this command can take some time to complete. On a Vault Store database with 50 million archived items, rebuilding indexes can take in excess of two hours on an average enterprise-size server (two processors, 4 Gb memory).
The 2nd issue
affects ONLY customers who are using the database maintenance plan in SQL Server
2005 WHO HAVE NOT INSTALLED SQL SERVER 2005 SP1 to rebuild indexes::
The Index
Rebuild maintenance task, if included, has an option called Change free
space per page percentage to. If this is set, the percentage figure is
wrongly interpreted as the Fill Factor.
For example: A
Change free space per page percentage to figure of 10% should set the
Fill Factor to 90%; however, it actually sets it to 10%. This is
equivalent to setting the free space per page to 90%. This will increase the
size of the database and may lead to disk space problems.
The
T-SQL script generated for the rebuild index task shows the fill factor
as 10% instead of 90%. It is advisable to check the SQL generated by the
maintenance task by editing and clicking in the View T_SQL button.
Inspect the Fill Factor to see whether it has the required value.
Alternatively verify by querying the sys.indexes table after the rebuild
index job has run.
In order to
resolve this issue, customers are recommended to upgrade SQL 2005 to Service
Pack 1.
Acknowledgements
Microsoft
Microsoft
Products Applied:
Enterprise Vault Compliance Accelerator 2007 7.5, 2007 7.5 SP1, 2007 7.5 SP2, 2007 7.5 SP3, 2007 7.5 SP4, 2007 7.5 SP5, 2007 7.5 SP6, 5.1 SP4, 6.0 SP1, 6.0 SP2, 6.0 SP3, 6.0 SP4, 7.0, 7.0 SP1, 7.0 SP2, 7.0 SP3, 7.0 SP4, 7.0 SP5, 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Enterprise Vault Discovery Accelerator 2007 7.5, 2007 7.5 SP1, 2007 7.5 SP2, 2007 7.5 SP3, 2007 7.5 SP4, 2007 7.5 SP5, 2007 7.5 SP6, 5.0 SP4, 6.0 SP1, 6.0 SP2, 6.0 SP3, 7.0, 7.0 SP1, 7.0 SP2, 7.0 SP3, 7.0 SP4, 7.0 SP5, 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Enterprise Vault for File System Archiving 2007 7.5, 2007 7.5 SP1, 2007 7.5 SP2, 2007 7.5 SP3, 2007 7.5 SP4, 2007 7.5 SP5, 2007 7.5 SP6, 5.0 SP6, 6.0 SP1, 6.0 SP2, 6.0 SP3, 6.0 SP4, 6.0 SP5, 6.0 SP6, 7.0, 7.0 SP1, 7.0 SP2, 7.0 SP3, 7.0 SP4, 7.0 SP5, 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Enterprise Vault for Lotus Domino 2007 7.5, 2007 7.5 SP1, 2007 7.5 SP2, 2007 7.5 SP3, 2007 7.5 SP4, 2007 7.5 SP5, 2007 7.5 SP6, 6.0 SP1, 6.0 SP2, 6.0 SP3, 6.0 SP4, 6.0 SP5, 6.0 SP6, 7.0, 7.0 SP1, 7.0 SP2, 7.0 SP3, 7.0 SP4, 7.0 SP5, 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Enterprise Vault for Microsoft Exchange 2007 7.5, 2007 7.5 SP1, 2007 7.5 SP2, 2007 7.5 SP3, 2007 7.5 SP4, 2007 7.5 SP5, 2007 7.5 SP6, 5.0 SP6, 6.0 SP1, 6.0 SP2, 6.0 SP3, 6.0 SP4, 6.0 SP5, 6.0 SP6, 7.0, 7.0 SP1, 7.0 SP2, 7.0 SP3, 7.0 SP4, 7.0 SP5, 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Enterprise Vault for Microsoft Sharepoint 2007 7.5, 2007 7.5 SP1, 2007 7.5 SP2, 2007 7.5 SP3, 2007 7.5 SP4, 2007 7.5 SP5, 2007 7.5 SP6, 5.0 SP6, 6.0 SP1, 6.0 SP2, 6.0 SP3, 6.0 SP4, 6.0 SP5, 6.0 SP6, 7.0, 7.0 SP1, 7.0 SP2, 7.0 SP3, 7.0 SP4, 7.0 SP5, 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Enterprise Vault for SMTP 2007 7.5, 2007 7.5 SP1, 2007 7.5 SP2, 2007 7.5 SP3, 2007 7.5 SP4, 2007 7.5 SP5, 2007 7.5 SP6, 6.0 SP1, 6.0 SP2, 6.0 SP3, 6.0 SP4, 6.0 SP5, 6.0 SP6, 7.0, 7.0 SP1, 7.0 SP2, 7.0 SP3, 7.0 SP4, 7.0 SP5, 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Enterprise Vault Compliance Accelerator 2007 7.5, 2007 7.5 SP1, 2007 7.5 SP2, 2007 7.5 SP3, 2007 7.5 SP4, 2007 7.5 SP5, 2007 7.5 SP6, 5.1 SP4, 6.0 SP1, 6.0 SP2, 6.0 SP3, 6.0 SP4, 7.0, 7.0 SP1, 7.0 SP2, 7.0 SP3, 7.0 SP4, 7.0 SP5, 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Enterprise Vault Discovery Accelerator 2007 7.5, 2007 7.5 SP1, 2007 7.5 SP2, 2007 7.5 SP3, 2007 7.5 SP4, 2007 7.5 SP5, 2007 7.5 SP6, 5.0 SP4, 6.0 SP1, 6.0 SP2, 6.0 SP3, 7.0, 7.0 SP1, 7.0 SP2, 7.0 SP3, 7.0 SP4, 7.0 SP5, 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Enterprise Vault for File System Archiving 2007 7.5, 2007 7.5 SP1, 2007 7.5 SP2, 2007 7.5 SP3, 2007 7.5 SP4, 2007 7.5 SP5, 2007 7.5 SP6, 5.0 SP6, 6.0 SP1, 6.0 SP2, 6.0 SP3, 6.0 SP4, 6.0 SP5, 6.0 SP6, 7.0, 7.0 SP1, 7.0 SP2, 7.0 SP3, 7.0 SP4, 7.0 SP5, 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Enterprise Vault for Lotus Domino 2007 7.5, 2007 7.5 SP1, 2007 7.5 SP2, 2007 7.5 SP3, 2007 7.5 SP4, 2007 7.5 SP5, 2007 7.5 SP6, 6.0 SP1, 6.0 SP2, 6.0 SP3, 6.0 SP4, 6.0 SP5, 6.0 SP6, 7.0, 7.0 SP1, 7.0 SP2, 7.0 SP3, 7.0 SP4, 7.0 SP5, 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Enterprise Vault for Microsoft Exchange 2007 7.5, 2007 7.5 SP1, 2007 7.5 SP2, 2007 7.5 SP3, 2007 7.5 SP4, 2007 7.5 SP5, 2007 7.5 SP6, 5.0 SP6, 6.0 SP1, 6.0 SP2, 6.0 SP3, 6.0 SP4, 6.0 SP5, 6.0 SP6, 7.0, 7.0 SP1, 7.0 SP2, 7.0 SP3, 7.0 SP4, 7.0 SP5, 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Enterprise Vault for Microsoft Sharepoint 2007 7.5, 2007 7.5 SP1, 2007 7.5 SP2, 2007 7.5 SP3, 2007 7.5 SP4, 2007 7.5 SP5, 2007 7.5 SP6, 5.0 SP6, 6.0 SP1, 6.0 SP2, 6.0 SP3, 6.0 SP4, 6.0 SP5, 6.0 SP6, 7.0, 7.0 SP1, 7.0 SP2, 7.0 SP3, 7.0 SP4, 7.0 SP5, 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Enterprise Vault for SMTP 2007 7.5, 2007 7.5 SP1, 2007 7.5 SP2, 2007 7.5 SP3, 2007 7.5 SP4, 2007 7.5 SP5, 2007 7.5 SP6, 6.0 SP1, 6.0 SP2, 6.0 SP3, 6.0 SP4, 6.0 SP5, 6.0 SP6, 7.0, 7.0 SP1, 7.0 SP2, 7.0 SP3, 7.0 SP4, 7.0 SP5, 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Last Updated: November 16 2009 02:44 AM GMT
Expires on: 11-16-2010
Subscribe to receive critical updates about this document
Expires on: 11-16-2010
Subscribe to receive critical updates about this document
Subjects:
Enterprise Vault Compliance Accelerator
Database: Configuration
Enterprise Vault Discovery Accelerator
Database: Configuration
Enterprise Vault for File System Archiving
Sql: Interoperability
Enterprise Vault for Lotus Domino
Sql: Interoperability
Enterprise Vault for Microsoft Exchange
Sql: Interoperability
Enterprise Vault for Microsoft Sharepoint
Documentation: Configuration
Enterprise Vault for SMTP
Documentation: Configuration
Enterprise Vault Compliance Accelerator
Database: Configuration
Enterprise Vault Discovery Accelerator
Database: Configuration
Enterprise Vault for File System Archiving
Sql: Interoperability
Enterprise Vault for Lotus Domino
Sql: Interoperability
Enterprise Vault for Microsoft Exchange
Sql: Interoperability
Enterprise Vault for Microsoft Sharepoint
Documentation: Configuration
Enterprise Vault for SMTP
Documentation: Configuration
Languages:
English (US), Japanese
English (US), Japanese
Operating Systems:
Windows 2000
Windows 2000
Advanced Server SP1, Advanced Server SP2, Advanced Server SP3, Advanced Server SP4, Datacenter Server SP1, Datacenter Server SP2, Datacenter Server SP3, Datacenter Server SP4, Server SP1, Server SP2, Server SP3, Server SP4
Windows Server 2003
DataCenter, DataCenter SP1, DataCenter SP2, Enterprise SP2, Enterprise Server, Enterprise ServerSP1, R2, Standard Server, Standard Server SP1, Standard Server SP2
Windows Server 2008
DataCenter (x64-64bit), DataCenter (x64-64bit) SP2, DataCenter (x86-32bit), DataCenter (x86-32bit) SP2, Enterprise (x64-64bit), Enterprise (x64-64bit) SP2, Enterprise (x86-32bit), Enterprise (x86-32bit) SP2, Standard (x64-64bit), Standard (x64-64bit) SP2, Standard (x86-32bit), Standard (x86-32bit) SP2
Symantec World Headquarters:
20330 Stevens Creek Blvd. Cupertino, CA 95014
World Wide Web: http://www.symantec.com,
Tech Support Web: http://entsupport.symantec.com,
E-Mail Support: http://seer.entsupport.symantec.com/email_forms,
FTP: ftp://ftp.entsupport.symantec.com or http://ftp.entsupport.symantec.com
20330 Stevens Creek Blvd. Cupertino, CA 95014
World Wide Web: http://www.symantec.com,
Tech Support Web: http://entsupport.symantec.com,
E-Mail Support: http://seer.entsupport.symantec.com/email_forms,
FTP: ftp://ftp.entsupport.symantec.com or http://ftp.entsupport.symantec.com
THE INFORMATION PROVIDED IN THE SYMANTEC SOFTWARE KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. SYMANTEC SOFTWARE DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL SYMANTEC SOFTWARE OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES,EVEN IF SYMANTEC SOFTWARE OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.