Viewing 15 posts - 76 through 90 (of 195 total)
thats rich, all you've told him to do is run perfom. What about a list of the counters to use. A simple google search or search on this site would...
December 28, 2008 at 1:08 pm
RAID 10 will generally offer a performance boost over RAID1 due to the striping across mirrored sets. As SQL server writes to the data files are a fairly random affair...
December 28, 2008 at 1:05 pm
Perry Whittle (12/28/2008)
jlp3630 (12/27/2008)
Assuming that the system was running, how would you go about systematically getting baselines for reads/writes?
as you say, depends if the system is already live. If your...
December 28, 2008 at 8:57 am
i would say the RAID 10 array is best as it offers the best performance and fault tolerance combined into one package. The downside of RAID 10 is the disk...
December 24, 2008 at 3:37 pm
Ah, I see, I misunderstood the intent of your question. Sorry...
No apologies necessary! 🙂
December 24, 2008 at 8:30 am
RBarryYoung (12/23/2008)
You should worry about your Log file before you add a second data file.
Ummm....thanks....but kinda not the point of the post. I'm looking for technical reasons why a single...
December 23, 2008 at 2:19 pm
I would double check that delegation is set up for the servers in AD using the AD Users and Computers snapin.
December 19, 2008 at 10:25 am
By checked delegation do you mean you went into the AD Users and Computers console?
And you used the setspn utility to create the SPN, right?
(Sorry, just trying to be clear...
December 19, 2008 at 10:14 am
Have you:
- Checked delegation settings in AD for Server B and the domain account SQL is running as on Server B?
- Created SPNs for Server B and Server C?
- Restarted...
December 19, 2008 at 9:36 am
There are two ways - the oldest synchronized transaction for your subscription has exceeded the value set in the publication (Publication Properties -> General Page) or the value set at...
December 18, 2008 at 10:17 am
Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods.
Are you using one of these on...
December 18, 2008 at 9:32 am
It means that the distribution agent is delivering large volumes of transactions and is reporting its status as "Delivering Replicated Transactions". Run profiler on your subscriber (with the appropriate filters,...
December 18, 2008 at 9:28 am
Be aware that since distribution agents each run in their own process you run the risk of running out of non-interactive desktop heap. There are two ways around the problem:...
December 18, 2008 at 9:23 am
Just visited the product URL and they have a nice graphic proclaiming "Now For Blackberry!"
December 17, 2008 at 1:57 pm
No, leave it manual. Identity Range management only applies to Merge and Transactional with Updateable Subscribers. BOL details how to manage identity columns in replication here: http://msdn.microsoft.com/en-us/library/ms151736(SQL.90).aspx
December 17, 2008 at 12:31 pm
Viewing 15 posts - 76 through 90 (of 195 total)