Leehbi,

Designed and configured properly you will be limited by HBA’s and/or limits placed on the storage frame. Storage can handle much more than one host. Two dual port HBA’s with...

Bwelch42,

The issue is storage latency. Use perfmon to validate and provide proof to your vm admin.

Gary1,

Traces started by Profiler are recorded in the errorlog. sp_readerrorlog 0, 1, ‘trace’.

CIS Benchmarks, Microsoft offers a SQL Security RAP.

Service account has "logon to" rights in AD to the new node?

Create an account with Oracle to access documentation on implementing Golden Gate.

Golden Gate uses an agent to marshal data, performance is dependent of configuration, latency and throughput.

Dan

Allin,

Yes, database mirroring was designed for Disaster Recovery. There are some concerns in using snapshots for reporting, users will be disconnected when snapshots occur, the data will be as current...

Marios,

At least I got your name correct this time, sorry about that.

So it appears we have a server rotating the trace file every 30 minuntes. That's an issue. Since maxfilesize...

My understanding is default trace rotates based on volume (20MB) and service restarts. Older files will be named log_n.trc, where n equals the number of rotations. Point your query to...

Default trace.

Dan

>1- Share load of one single large DB with high transaction rate on multiple servers?

Oracle RAC

>2- Share multiple related DBs load on multiple servers?

Install another instance.

If one server isn't...

sp_readerrorlog, look for the entry "Logging SQL Server messages in file "

Dan

Nick,

Delete unchanged records from the staging table prior to the mass update. This removes the "has price changed" logic from the Product table update.

Dan

Anthony,

We have a lengthy document describing what data DBA's are permitted to access. You may want to engage HR and Legal in drafting your own data accessability guidelines and rules.

The...

Look at sp_trace_create @options.

Dan