|
Do I need a separate license for Windows Server 200X to run a warm standby server?
I have a Windows Server 2003 machine running SQL Server 2005. I also have a Windows Server 2008 machine running SQL Server 2005. I know I'm good on the SQL Server 2005 ...
Started by DBAndrew on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
Windows does not have the same licensing goodness for warm.
Yes, you will need a separate license.
|
|
I have two identical servers with SQL Server 2005 and my application.
Hard requirements:
I must be able to update data at either server. I must be able to unplug either server without having to reconfigure anything in the database. When a server is plugged...
Started by Eric Lathrop on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Have you considered Log Shipping?
I don't think that can easily be set up so that the Warm-standby the secondary server..
|
|
We have a job which runs every morning in CruiseControl.net to import a datafile into a DB. Our problem seems to be that some nights the DB goes to sleep over night. When we run the script in the morning our connection times out while we wait for the ...
Started by Pete Duncanson on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
ALTER DATABASE ....
Could you schedule a query 30 minutes before your build process runs to "warm up" the server?
Also- is this database running on a server or desktop? If it's a desktop you might check the power management settings.
|
Ask your Facebook Friends
|
When I am testing a query I will typically drop the following lines in front of whatever i am testing to make sure I'm starting from the same baseline every time i run a query.
CHECKPOINT GO DBCC FREEPROCCACHE GO DBCC DROPCLEANBUFFERS GO EXEC sp_MyProc...
Started by Abe Miessler on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
I came across this MSDN article on how to see what is in the SQL Server cache in this question!
I would have initially....
When you subsequently interested in.
Of this behaviour, it can be beneficial to warm-up a SQL Server database for use.
|
|
Is it a good idea to warm up cache in the BEGIN block, when it gets used?
Started by Timmy on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
By warm up I assume you mean use BEGIN() to guarantee the cache is preloaded before anything else.
|
|
Hi everyone, i am moving to a new file server under Server 2008 Standard 32bit edition. I will refer to the older server as just "server", the new one i named as server2.
i have updated server2 and patched it. I have also joined the domain as member server...
Started by dasko on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at serverfault):
I am assuming....
It works that while undomained.
Which is to say, you CAN do it just like you found out .
Server 2008 may be different, but in general I try to avoid renaming Windows servers whenever of renaming a long-standing server.
|
|
We have speed problems in corporate enviroment.
Most of the notebooks are strongly loaded: the start-up time of Excel is 3-5 minutes, Outlook 10-15 minutes etc.
Our application has the same start-up time, instead of the normal 10-20 seconds. If once it...
Started by boj on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at superuser):
When you close that ....
In which case when you start your applications they will have to swap previously running applications into virtual memory .
What do you mean strongly loaded?
From your symptoms the problem might be that they do not have enough RAM .
|
|
I have a DB table with 25M rows, ~3K each (i.e. ~75GB), that together with multiple indexes I use (an additional 15-20GB) will not fit entirely in memory (64GB on machine). A typical query locates 300 rows thru an index, optionally filters them down to...
Started by Shaul Dar on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
That you know that are important, and run them on cold server? the more the queries you'll run, the better.
|
|
I am wondering if anyone has any plugins or capistrano recipes that will "pre-heat" the page cache for a rails app by building all of the page cached html at the time the deployment is made, or locally before deployment happens.
I have some mostly static...
Started by Scott Miller on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
\ --wait=2 --waitretry=10 \ --server-response \ --append-output=/tmp/spidering-`date "+%Y%m%d"`.log.
|
|
Is Global Warming a Hoax? ClimateGate - Climate center's server hacked revealing documents and emails
Britain’s Climate Research Unit, University of East Anglia, suffered a data breach in recent days when a hacker apparently broke into their system and...
Answer Snippets (Read the full thread at thinkdigit):
Re: Is Global Warming.
As development means using technology that makes the world go warm.
And comprehension, and that there are periods when the planet is warm and when it is cool
When you underdeveloped only.
|
