Viewing 15 posts - 8,761 through 8,775 (of 9,241 total)
although you ran a log backup there could be an active transaction occupying the end of the log file
run
dbcc opentran to check for open transactions
then
dbcc loginfo
a status of 2...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2008 at 12:15 pm
Ninja's_RGR'us (11/15/2008)
Any recommended products from your experience?
personally you cant beat VMWare VI3. There are a number of players in this arena now, but remember VMWare have a 10 year +...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2008 at 12:04 pm
you need to research and decide on a virtualisation product and storage method first then build from there as the hypervisor and storage mediums form the foundation of the systems
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2008 at 4:33 am
Andrew Peterson (11/5/2008)
The simple approach is to drop and restore the logins with the sid as part of the create login command.
why not just script off the logins from the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2008 at 6:24 am
definitely shutdown SQL server instances.
make sure you have a full backup of the data files before defrag.
Rebuild all your indexes after the defrag
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2008 at 3:28 am
Hi
the first question i need to ask you is
what platform are you using for virtualisation?
We currently use VMWare VI3 comprising of 10 ESX 3.5 hosts
Dont get ESX server confused...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2008 at 3:17 am
stacked IP addresses are another way to have SQL listen on multiple IP's and ports
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 12, 2008 at 3:43 pm
Steve Jones - Editor (11/12/2008)
You can't, but if it's a daily load, why do you care? The space will get reused tomorrow.
that's a very valid point
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 12, 2008 at 3:38 pm
rbarryyoung (11/12/2008)
3GB does not sound like anywhere near enough memory for 1000 databases.
unless of course they're all copies of Northwind and Pubs 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 12, 2008 at 3:13 pm
Dean Jones (11/12/2008)
when enabled and doenst really solve the issue of SQL CLR taking up the whole VAS memory area.
that's not what AWE is for. AWE is so that each...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 12, 2008 at 3:10 pm
thats more like it although essentially with node 5 inactive you could argue you still have active\passive clustering 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 12, 2008 at 10:15 am
GilaMonster (11/12/2008)
indexes were been rebuilt sunday evening. Those are logged operations and the log reader has to read through them.
not logged under simple or bulk logged recovery models 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 12, 2008 at 9:59 am
mtassin (11/12/2008)
Well presently it's a 4 node all active cluster with 3 GB of Ram given to each SQL instance.
if the cluster has only 2 instances then 4...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 12, 2008 at 9:47 am
if you have 4GB RAM or over you need to enable AWE for each instance. What version OS do you use and what version SQL server. You should also configure...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 12, 2008 at 9:40 am
Mike Levan (11/12/2008)
Many DBa's say that shrinking is a bad idea,
in a word "fragmentation"
Mike Levan (11/12/2008)
but that is what we do to gain disk space every time.
i hope not,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 12, 2008 at 9:35 am
Viewing 15 posts - 8,761 through 8,775 (of 9,241 total)