Thanks alot for all of your information..

As mentioned above there is multivalued properties limitation using ADSI and also can only be able to query 1000 objects as mentioned in below...

Hi Gail Shaw,

Thanks alot for your technical advice. Now I can select the data.

You are the master..

BR,

Parthi

Hi GKramer/GSquared,

Sorry for the late reply. Thank you for your valuable information.

I will try it and back to you for any problem.

BR,

Parthi

sorry for the confusion. Please delete the thread.

BR,

Parthi

Jeff,

Thank you for your help..

We already checked fragementation and there are no index and data fragementation as beow,

DBCC SHOWCONTIG scanning 'T12' table...

Table: 'T12' (1781581385); index ID: 1, database ID: 7

TABLE...

there is a typo,

there are no data corruption in the table.

Hi,

I already rebuilded the index, updated the usage of sysindexes and also updated the statistics of the index.

Please suggest me that the corresponding index should be manually dropped and recreated?...

As asked earlier, please confirm that lock pages in memory will work on x64bit sql server 2005 standard edition installed on active/passive server as I can find in the below...

Also I found that the service account should have enough rights to lock the pages in memory on both the nodes. How can I check this permission on windows login...

Hi All,

After enabling lock pages in memory and reindexing all user databases, the user commented the performance of the server is fine. As an administrator we cannot find any difference....

Hi All,

Thank you for your technical advice.

We will implement the change this week.

Regards,

Parthipan

Colin,

We have enabled the lock pages in memory option.

Can you suggest me how much min and max memory values should I configure for the sql server.

As of now

Memory: 4.83GB

In sql...

I checked the event log in the server and can able to see information of hanging of sql management studio and sql configuration tool regularly with the following information,

Hanging application...

In the sql server properties the memory values are set as,

min memory = 0MB       Max memory = 2147483647MB

Please suggest us how much value we can keep in Min and max...

We already ran performance monitor on the below counters and the value are

SQL Server Buffer: Buffer Cache Hit Ratio - 99% normal

Memory\Available Bytes: The server has an average of...