Dont think there are commands to optimize database performance, but there are metnhodologies at verious level to improve performance whcih you can look up MSDN or performance article's here in...

Would advice to check the hardware related counter to determine bottleneck as listed below if you have not checked.

How good is DISK IO ? Check the counters DISK sec/read and...

Suggest check with windows server expert on msdn , one link on similar issue seems like a bug.

http://social.technet.microsoft.com/Forums/en-US/windowsserver2008r2management/thread/bb623545-f68f-41a0-8f71-e6f4b9da7a3b

Cheers

Sat

Asumming these updates are based on particular period of time say on 6 months of data , but it is scanning older data as well then probably partition is way...

Some things to check ...

Is the ping reponse < 10ms for SYNC mirror set up ? If yes there may network latency.

Usually we have 30ms thrshold set for SYNC with...

Once you move to problem node , close the Faliover CLuster Manager and on re-open does it take more than 30 seconds to populate the SQL server instance ?

Also going...

One question though if you execute you should get error below,

Msg 134, Level 15, State 1, Line 9

The variable name '@sqlstring' has already been declared. Variable names must be...

Having the same issue any help would be great

EXEC sp_addlinkedserver

@server='TEST_OLAP', /* local SQL name given to the */

...

SQL 2008 r2

The tool which looks at memory also showed low Free memory Less than 1GB

Also Paging errors reported with Commited Bytes > Available memory.

Cheers

Satish

Is this user part of the same schema for example default dbo schema ?

Also what happens if the user uses complate path <database name>.<schema name>.<view name> View name in query...

In case you want warm stand-by\Hot stand-by server then you need to have same capability on secondary server as the primary one if you go for mirroring or log shipping.

If...

This blogs explains most of stuff in detail and good read to understand it.

http://sqlnerd.blogspot.com/2005/06/index-fill-factor-performance.html

Cheers

Sat

Guess the quorum between the witness and mirror server instance was not formed.

did you query sys.database_mirrorring table to check states of each participant ?

Cheers

Sat

Is this production env or developer env with VS 2005\VS2008 on the same box as SQL server ?

Cheers

Sat

Did you try running profiler trace or enable trace flags to see exact code causing it ?

Cheers

Sat