Viewing 15 posts - 8,746 through 8,760 (of 9,244 total)
that's not how it works, a virtual CPU has no knowledge of cpu cores. The physical host is licenced per physical socket. You need to weigh up your licensing requirements....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2008 at 6:14 am
that's not what he requires
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2008 at 6:06 am
your welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2008 at 5:47 am
Ted Stryker (11/19/2008)
There's nothing else running on the box, max server memory is set to leave 6gb for the OS and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2008 at 5:16 am
venki
you can of course also use the management studio if you prefer GUI interraction
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2008 at 4:59 pm
Leo (11/18/2008)
Why RAID 5 need minimum of 3 drives?
Leo (11/18/2008)
Disk 2 -Promise 1+0 Stripe/RAID 0 SCSI DISK (400GB FREE)
RAID 1+0, this requires even more disks than RAID 5. It would...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2008 at 4:55 pm
ssismaddy (11/18/2008)
It is replicated and we can't change the recovery model....But I m all set now with the dynamic views above....Thank you
even if it is replicated you can still change...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2008 at 4:42 pm
to delete a trace you have to stop and close it
exec sp_trace_setstatus traceid, 0 --stop trace
exec sp_trace_setstatus traceid, 2 --close trace
all of this is no good until you know the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2008 at 10:53 am
SQL2005 must be licenced per virtual processor. However if you licence the physical sockets on the host box you are covered for unlimited virtual cpus\VM's on that host
check for more...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2008 at 10:50 am
Leo (11/17/2008)
I have similar situation at work. My IT guys build a Test Server for SQL 2005 and he said that we have 2 400GB x RAID 5 drives...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2008 at 5:45 am
it's also worth noting that under bulk logged and simple recovery models the following are minimally logged
ALTER INDEX
CREATE INDEX
we always set our db recovery models to bulk logged, rebuild indexes...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2008 at 5:38 am
i have books from Wrox which are fantastic
Professional SQL 2005 programming
Professional SQL2005 performance tuning
I recommend these. They go into a lot of detail about the database engine (datafiles, logfiles,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2008 at 10:28 am
it could be the backup is larger than the free space available!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2008 at 10:12 am
database mirroring provides a warm standy copy of the database.
Log shipping works differently, log files are shipped to a remote database and applied. The database has 1 of 2 states,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2008 at 10:10 am
samuel.tillman (11/10/2008)
6x72GB HHDs. What I have been asked to do specifically is setup the raid configuration and the backup scheme for the Databases and Transaction Logs.
RAID 5 is ideal for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2008 at 6:24 am
Viewing 15 posts - 8,746 through 8,760 (of 9,244 total)