just found out that option will not work on the SP level only statement and server level, this also running on 2005 therefore its outside of the sql so probably...

in that case use the ole db source connect to the master db and select the sql command on the drop down

form here you can just enter the whole...

1. in the control flow tab, create a data flow task

2. then in the data flow tab create a ole DB SOURCE

3. then connect to the Db and the table...

my guess is you have 594.500 MB not 594,500 MB....if so these tables are probably not big enough to see much of a diff...

you said you moved the tempdb to...

Try this its better yet.

http://www.sql-server-performance.com/articles/audit/hardware_bottlenecks_p1.aspx

try this

http://blogs.technet.com/vipulshah/archive/2006/11/30/understanding-perfmon-counters-while-troubleshooting-sql-server-performance-issues.aspx

just a quick check when you say active/active....sql is not truly active active as Oracle is..meaning both nodes will not share the load of the production environment...although you can have...

We are running the same thing you are setting up... I would do just as you are planning..

but we have a server that that uses log shipping from our production...

This will get you started

http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/

no the will not be ignored...but in prior version of standard lock pages was not an option...

my best guess is the OS or another application if you are running any...

Sorry I didnt word it right, but your note is a memory dump, the os ran out of memory. on our cluster environment is caused our primary server to restart...

I ageee with JEFF the 3rd party tools point to a direction but you still need the skills to fix it!

The ones you have listed are both good...quest and idera....

Like...

also one other note it very possible that the memory dropped, if you do not have a max memory setting set sql will and can page memory out.. as SQL...

run your profiler, under buffer manager use total and target pages......you can watch it here set for a about every 5 min and save to csv file...sometime depending on your...

thanks that worked