RAC v2.2 & QALite!
Quote:> Is there functionality available that would judge the cost
> of a query before running and let the user know that what
> they are attempting to do will take a while? I have used
> execution plans before, but is there a way to return
> information that could be displayed to a user before the
> query is executed?
I am wondering a couple of things.
I am in the planning stages of a new database server for my company.
We are moving from Informix, Oracle, and dbaseIV to SQL Server.
I want to implement a 2-server cluster using Windows 2000 Advanced Server running
Cluster Service. Each server will be dual processor.
Only one server will be active. When the primary fails, the backup will come
Do I need SQL Server Enterprise Edition?
How would I configure SQL Server to work with MS Cluster Service?
My next question is about snapshots.
I estimate, based on current database usage, that company wide, we will probably
performa about 50,000 transactions per day on the database.
Because of the nature of the business, we can not have the SQL Server stop
running for any lengthy period of time (read: > 1 hour), and due to the size of
the database (> 40 gigs), I was wondering if a snapshot of the transaction log
would be an appropriate solution to the backup issue before me.
Any ideas or suggestions?