Thanks again Bill...I installed the drivers and configured them...but when I tried to create the linked server it hangs...continuous running..its been 45 mins now..i amthinking to kill the process

Also, should I have the MAS90 drivers installed on the server where SQL Server is installed?

Thanks a lot for your help

While configuring the linked server, which user shd i specify in the security tab of the new linked server window? I meant the "Local Server Login to remote server login...

Thanks for the url

Thanks much for the article Ron. For the perfmon counters where can I get the threshold values.

OK Thanks...

Ninja..for the indexing I have identified the top 50 high cpu consuming queries and went by each individual graphical execution plans and created the non clustered indexes suggested by the...

Ninja

Please find the image attached

Gail,

I noticed too many sql timeouts yesterday night. WHen I query on the monitor table i have in place I was seeing some of the sessions were in suspended status...

NINJA Please find the result set below:

WaitType Wait_SAvgWait_MSResource_S Signal_SWaitCountPercentage

ASYNC_NETWORK_IO137941.7179.08 ...

Yep..that works..I was on a different database. Thanks Gail.

I used the script below to identify the name of the object. But all I see is nothing in the output. Do I need to enable a trace flag for...

OK Thanks

Thanks Jared I will start digging into these

Also, In the sql server error log I am seeing the below errors at the same time when the timeouts occurred.

Process 0:0:0 (0x864)...