Major new features that you should get familiar with

1. Policy Based Management

2. Resource Governor

3. Auditing

4. Change Data Capture

5. Backup & Data Compression

6. Central Management Server

7. Performance Data Collector

8. Filtered Indexes

9....

Try to install the Backward Compatibility Tools and DTS designer Components for SQL Server 2005 . It should resolve the issue.

You can download them from this link.

http://www.microsoft.com/downloads/en/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

To delete a package...

Grant is Right.. Follow his advice. RML Utilities is a good tool for the analysis.

Thank...

Check this link ..

http://realworlddba.wordpress.com/2008/02/25/analyzing-performance-monitor-data-with-sql-server-profiler/

Thank You,

Best Regards,

SQLBuddy

You can Do that...

To get the resource utilization , start a perfmon counter Log .

To capture the SQL Queries, start a SQL Server profiler.

Then you can import perfmon data into...

Check if the previous versions are getting deleted for that package somehow from the MSDB.

Thank You,

Best...

After making the recommended changes, how much memory is SQL Server using ?

Thank You,

Best Regards,

SQLBuddy

DBID () func in the DMV will return in a error for 80 comp Mode dbs. It doesn't return complete information for 80 comp mode databases. May be it's due...

Is the problem resolved ? Could you provide us an update ?

Thank You,

Best Regards,

SQLBuddy

It doesn't work if there is a 80 compatibility mode database. It gives an error for DB_ID() function. If you manually enter the Database ID in its place it will...

Do the following for Maintenance.

1. Reorg indexes on Nightly Basis

2. Update stats on Nightly Basis

3. Rebuild indexes on Weekly Basis

4. DBCC CheckDB on Weekly Basis

The thresholds should something be like...

Check this one

---- Query to find the Fill Factor and index fragmentation

SELECT

db_name() AS DbName,

SCHEMA_NAME(B.schema_id) AS SchemaName

, B.name AS TableName

, C.name AS IndexName

, A.INDEX_DEPTH as Index_depth

,...

SQLMyFriend (5/12/2011)

1. Even if you add additional memory, it is necessary to configure the above settings to get optimum Performance. If it is dedicated SQL Server BOx, then always enable...

State 11 means the domain login trying to access sql server that wasnt explicitly added to sql server .Even though it can access OS, it cant login in to sql...

This indicates that SQL Server is using only 1.6 GB of Memory in spite of the 12 GB Max Memory.

What is...