Viewing 15 posts - 8,971 through 8,985 (of 9,241 total)
Thayal Muhunthan (8/22/2008)
FOr SQL data, logs, tempDB, I have SAN disk.
if the RAID 10 storage for all this is SAN based then thats a different situation all together. 146...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2008 at 9:43 am
Ray Herring (8/21/2008)
and your growth is small then you can end up with a very large, very fragmented file.
shrinking and growing files can cause fragmentation at the file level too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2008 at 4:41 pm
DBCC LOGINFO should show the status of the log file.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2008 at 4:24 pm
what is min memory set to on the instances?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2008 at 4:22 pm
theres no point in RAID 10 for the OS thats just a waste of disks (these would be local disks anyway presumably).
Use RAID 1 for OS
all depends on how...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2008 at 4:09 pm
Developer edition offers all the features of enterprise, as a developer you would want to use this edition (hence its name 😉 )
if you need a server installation to eventually...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2008 at 1:12 pm
Thayal Muhunthan (8/21/2008)
We have 2XQUAD processors. Do we go for SQL 2005 standard or Enterprise ?
do you plan to use the Enterprise features or not, in most cases SQL2005...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2008 at 10:02 am
GilaMonster (8/21/2008)I thought it was worth repeating and expanding on.
for sure, considering he still mentioned using it 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2008 at 8:52 am
Wilfred van Dijk (8/21/2008)
AFAIK, you need to restart SQL in order to make these changes for @@SERVERNAME
yes that is correct
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2008 at 8:50 am
GilaMonster (8/20/2008)
You can't do Raid 10 (striped and mirrored) with only two drives. It requires a minimum of 4.
Gail i pointed this out already but he still plans to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2008 at 5:51 am
SQL Noob (8/20/2008)
this applies only to 32 bit versions
according to the MS features the only memory caveats are for 64GB RAM and above
SQL2005 Std however will support OS max RAM
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2008 at 5:47 am
windows authentication is a default, when you rebuilt did you script off any login info before hand? like sql logins, windows logins have to be added to the server too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2008 at 5:38 am
Edwin (8/20/2008)
Hi Perry,
We are planning to put in 32 GB RAM with Window Server 2003 Enterprise 32-bits edition.
Yes, I am considering the Window Server 2003 Enterprise 64-bits edition.
The databases...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2008 at 4:29 am
CR8NK (8/20/2008)
C:\34 gb 1 disk raid 1 for OSE:\34 gb 1 disk raid 1 for logs
how do you intend to RAID 1 with only 1 disk for each.
you could RAID...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2008 at 4:13 am
a sticky plaster rather than a cure. TCP/IP is more secure, check the SPN's i'm sure they'll be the source of your problem. Do the sql services run as a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2008 at 4:11 am
Viewing 15 posts - 8,971 through 8,985 (of 9,241 total)