Viewing 15 posts - 25,321 through 25,335 (of 39,958 total)
Definitely specifically limit memory for each instance. The resource issues are your biggest ones. We did this here at SSC and it worked fine.
Also be aware that one of these...
February 12, 2009 at 5:11 pm
If you explain what you want to do, we might have other ideas as well.
February 12, 2009 at 5:10 pm
I'm sure he will. They don't call Grant "The Scary DBA" for nothing!
February 12, 2009 at 5:07 pm
Clustering is expensive and it will handle the automatic failover, though it can be 10-60 seconds to move.
Mirroring is the best solution, but you have to be using the SNAC...
February 12, 2009 at 4:33 pm
Is this W2K3?
I heard from a friend that the machines will connect across as doman/computername$ and this should work. Seems wrong to me, but perhaps it's behavior by design. Bad...
February 12, 2009 at 3:25 pm
Would you cosider trading for 99 Boxster?
Sorry, I'm an air cooled guy. I'd replace it with another 87-90 911, though I'd try for black this year.
February 12, 2009 at 1:27 pm
February 12, 2009 at 1:25 pm
You cannot limit by CALs. CALs are an administrative thing only; there's no setting in SQL to track this. Many applications might open more than one connection (like SSMS), so...
February 12, 2009 at 1:24 pm
The results aren't showing. Perhaps you could summarize what the throughput was?
February 12, 2009 at 1:23 pm
So the SQL Agent service and the SQL Server database service are running under "LocalSystem" or a local account? If the passwords are the same, it's possible that there is...
February 12, 2009 at 1:21 pm
Both of the suggestions above are what I'd recommend, but I'd also have "obfuscation scripts" ready and running when you need to update test or dev from production as well.
February 12, 2009 at 1:13 pm
I wouldn't necessarily move to maintenance plans. That's up to you, and they work fine, but there are limitations and great scripts here on the site that can help you...
February 12, 2009 at 1:12 pm
you can profile this and see the command being run, along with the dates passed in for removing files.
Often someone expects 2 days to mean 2 backups and they might...
February 12, 2009 at 1:09 pm
As mentioned, the Agent account, and the SQL service accounts, are used to often run things from the server. when you submit something from SSMS, it's running under the service...
February 12, 2009 at 1:08 pm
What do you mean "real tables"
Are these created with a VFP application?
February 12, 2009 at 12:55 pm
Viewing 15 posts - 25,321 through 25,335 (of 39,958 total)