Viewing 15 posts - 5,521 through 5,535 (of 9,253 total)
Remember that your offset is ultimately dependent upon your RAID stripe size, you probably shouldn't just accept the windows default. There are a whole bunch of calculations to make including...
June 2, 2012 at 1:51 am
opc.three (6/1/2012)
IIRC Server 2008 uses an offset of 1024KB as a default when provisioning a new disk
Yes it does it's a sort of one size fits all, default configuration.
opc.three (6/1/2012)
June 1, 2012 at 6:47 pm
Shark Energy (6/1/2012)
Good questions - I have that all written down for the old server but not for the new one.
Investigate thoroughly and compare them to see the differences.
Shark Energy...
June 1, 2012 at 6:20 pm
Why can't you just change the password and update the app connection?
June 1, 2012 at 6:06 pm
number of disks?
cache size?
RAID stripe size?
Storage paths?
There are so many factors that can have an effect.
June 1, 2012 at 2:37 pm
Before you just go detaching databases you may want to record their physical and logical filenames. Do this using
select 'Logical file ''' + name + ''' from database ' +...
June 1, 2012 at 2:11 pm
Don't know offhand, but just open up the restore window and try to locate the new drive, if it doesn't like it it will soon let you know.
June 1, 2012 at 4:50 am
srivathsani-296624 (5/31/2012)
We are not sure if the node is still a part of the cluster
Windows 2003 or Windows 2008?
May 31, 2012 at 4:26 pm
APA0876 (5/30/2012)
what do you recommend for 2 nodes active\active , 2 sql server instancesThanks
APA
Are you expecting a large amount of remote transactions on each instance? One DTC for each instance...
May 31, 2012 at 4:21 pm
SQL Kiwi (5/29/2012)
A recent discussion on the MVP mailing list came to the unanimous conclusion that 4GB was fine for large-memory systems.
Were they Windows server MVPs?
GilaMonster (5/29/2012)
May 29, 2012 at 4:10 am
michael vessey (5/28/2012)
does that include the heartbeat IP addresses as well?
No Mike, and for 3 very good reasons
➡ Your public network possibly services 100's or 1000's of IP addresses and...
May 28, 2012 at 3:52 pm
The page file is a windows host configuration best practice. Ideally you should size it appropriately and place it on a separate disk
May 28, 2012 at 3:43 pm
to get the date of the latest stats updates for a given database, use the following
SELECTt.name
, i.name AS index_name
, STATS_DATE(i.object_id, i.index_id) AS statistics_update_date
FROM sys.objects t inner join sys.indexes i
on...
May 28, 2012 at 10:02 am
viswanathan.mathi (5/28/2012)
Hi Friends,I want to know the no of ip address required for active passive cluster active/active cluster
You require
1 IP address for each cluster node
1...
May 28, 2012 at 9:54 am
Viewing 15 posts - 5,521 through 5,535 (of 9,253 total)