Viewing 15 posts - 3,091 through 3,105 (of 6,679 total)
I have done this same procedure on several systems - and it works quite well.
The last time we had to do this, I didn't even have to get involved. ...
July 4, 2011 at 12:23 pm
Ninja's_RGR'us (7/4/2011)
How do you estimate the impact of a slower processor speed when you are dealing with mostly oltp env? Olap? Hybrid?
Actually, I usually don't have to - because...
July 4, 2011 at 12:00 pm
vlad s (7/4/2011)
If you had these options to replace existing...
July 4, 2011 at 11:35 am
Ninja's_RGR'us (7/4/2011)
Why did you shy away from the option with 16 cores? I'm assuming here that you could have quoted even cheaper than 20k!
Because we already had 16 cores...
July 4, 2011 at 11:22 am
vlad s (7/4/2011)
One more CPU question. For SQL Server is it better to have more cache or faster speed?
For example Xeon X5672 12 MB 3.2 GHz...
July 4, 2011 at 11:03 am
GilaMonster (7/4/2011)
July 4, 2011 at 10:49 am
Very easy to see how so many people get it wrong. As a DBA - I have found that having a good relationship with the SAN guys, and/or a...
July 4, 2011 at 10:31 am
GilaMonster (7/4/2011)
July 4, 2011 at 10:24 am
You should be okay then - however, I would check with the business to see whether or not they anticipate any increased usage of the system over the next 3...
July 4, 2011 at 10:17 am
Perry Whittle (7/4/2011)
Jeffrey Williams-493691 (7/4/2011)
and it really does depend on how that particular SAN is configured and how the LUNs are carved out.
even right down to the HBA drivers. Most...
July 4, 2011 at 10:11 am
Perry, that is exactly the point I was trying to get to - it depends 😉
Each SAN does things differently - and it really does depend on how that particular...
July 4, 2011 at 9:55 am
What is your current CPU utilization on average for that system? If you are running at anything above 40% utilization on average - you would need to add CPU's.
If...
July 4, 2011 at 9:50 am
sqlzealot-81 (7/4/2011)
http://blogs.msdn.com/b/psssql/archive/2009/09/11/fun-with-locked-pages-awe-task-manager-and-the-working-set.aspxFound an article which is very interesting!!!
The question I asked has nothing to do with whether or not this is required. It has to do with whether or...
July 4, 2011 at 9:33 am
Syed Jahanzaib Bin hassan (7/4/2011)
More split on the same array will not improve the performance but management or maintenance purpose is valid for this
Okay - so you agree that your...
July 4, 2011 at 9:29 am
Is this an x64 system?
If so, did you set lock pages in memory right and also set max memory for SQL Server?
July 3, 2011 at 7:28 pm
Viewing 15 posts - 3,091 through 3,105 (of 6,679 total)