|
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.
|
|
Warm Standby SQL Server/Web Server
This question might fall into the IT category but as the lead developer I must come up with a solution to integration as well as pure software issues.
We just moved our web server off site and now I would like to keep...
Started by Ron Skufca on
, 7 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Your question also ties into my overall plan to implement log shipping:
SQL Server sp_cmdshell.
That would insert the names of the files that you moved into a table that your warm server could read.
|
|
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.
|
|
After *much* consideration (and many helpful hints here) I have decided that a local server is the way to go for our office. For the price of 2 months of service from our current provider, and at best 4 months from the lowest cost option I could find,...
Started by Maury Markowitz on
, 5 posts
by 3 people.
Answer Snippets (Read the full thread at webhostingtalk):
Getting the clue server up and running would require some.
The backup snapshot from the backup software.
|
|
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.
|
|
How can a computer increase increase GLobal warming?
Started by Charlee on
, 13 posts
by 13 people.
Answer Snippets (Read the full thread at yahoo):
Fibre all of which contributed to global warming in its manufacture, and which relies on massive server.
|
|
What are some effects of global warming? I have to do this enviroment poem and I'm doing it on global warming. I already put down the stuff about polar bears hunting grounds, weather change, but I don't know what else is being caused.
Started by Valerie Tran on
, 15 posts
by 15 people.
Answer Snippets (Read the full thread at yahoo):
-Longer.
-Fewer deaths or injuries due to cold weather.
For reliable climate info:
http://nasa.gov
http for energy consumption to warm cold places.
But the Yahoo server only allows me to post a maximum of ten.
|
