I have tested multiple primary key in single table.

PK - columname 1 - [id_no]

PK - columname 2 - [id_nos]

ALTER TABLE [dbo].[Index_testing] ADD CONSTRAINT [PK_Index_testing] PRIMARY KEY CLUSTERED

(

[id_no]...

SSIS pakages automatically loaded and created by when configure database backup thru Mnagement plan wizard...it may be cause currpted some dll files realted to DotNet 2.0 framework.... after restarting backup...

DELETE statement will be hang due to 76554566 total records.. any suggestion Pls.

Hi,

Thanks for your help.. I had successfully updated CU1 on SQL2K8R2 64 bit.

File name downloaded: SQLServer2008R2-KB2720425-x64

Existing Version: SQL2K8R2 SP2 version - 10.50.4000

Current version: SQL2K8R2 SP2 CU1 version - 10.50.4260

I have...

Thanks for reply .. please confirm

I have download file name is : SQLServer2008R2-KB2720425-x86, it can apply for 32 bit not for 64 bit..

I could not able to download 64 bit...

Thanks for reply.. could you pl.confirm which patch number should be download?

(http://support.microsoft.com/kb/2720425/ )

2720425

Cumulative Update package 1 for SQL Server 2008 R2 Service Pack 2

2703280

Cumulative Update package 14...

In SQL SERVER 2008 R2 64 bit, I had installed SP2, Not for CU1..

should I download SP2 CU1 and apply that patch..?

thanks

ananda

Thanks for your suggestion... First, I am going to install on dev setup after tested everything..then going for production setup...

Currently standard edition with SP1..I have doubts, can install sp3 before...

Thanks for reply.. some of the index result showing as below, it is treated as used index?

Index A

UserSeek - 193121

UserScans - 0

UserLookup- 0

UserUpdates - 49183

Index B

UserSeek - 0

UserScans - 0

UserLookup-...

Could you seems that error log file, which I was posted

I have ceate one table for storing output according timestamp as per that query result and schedule it every 15...

re-attach that error file

Date,Source,Severity,Message

04/06/2013 15:07:45,spid18s,Unknown,waiter id=process3f66c70 mode=X requestType=convert

04/06/2013 15:07:45,spid18s,Unknown,waiter-list

04/06/2013 15:07:45,spid18s,Unknown,owner id=process3e99390 mode=S

04/06/2013 15:07:45,spid18s,Unknown,owner-list

04/06/2013 15:07:45,spid18s,Unknown,keylock hobtid=72057594039566336 dbid=18 objectname=LRModel.dbo.Constraints indexname=PK_Constraints id=lock515a2800 mode=U associatedObjectId=72057594039566336

04/06/2013 15:07:45,spid18s,Unknown,waiter id=process3e99390 mode=S requestType=wait

04/06/2013 15:07:45,spid18s,Unknown,waiter-list

04/06/2013 15:07:45,spid18s,Unknown,owner id=process3f66c70 mode=RangeX-X

04/06/2013 15:07:45,spid18s,Unknown,owner-list

04/06/2013...

Thank you for reply..

Server OS - win 2008 Ent.edition

Database - SQL 2008 standard edition with sp1.. not updated any culmative patch and sp3.

I have switch on tace falg 1222 on...

Thank you for reply..

1. Please confirm, 'step3', is it really required?

the below command for adding PAE in boot.ini file in windows 2008 enterprise edition 32 bit operating system..

BCDEDIT /SET...

yes.. it is working, thanks

what is the best intervel time configure at scheduling job for monitoring IO usages?

Thanks

ananda

At minimum I would recommend checking the setting for 'max degree of parallelism' and making sure that is set to no more than 8, which is the number of physical...