Viewing 15 posts - 3,091 through 3,105 (of 6,676 total)
vlad s (7/4/2011)
If you had these options to replace existing...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 4, 2011 at 11:03 am
GilaMonster (7/4/2011)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 4, 2011 at 10:31 am
GilaMonster (7/4/2011)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 3, 2011 at 7:28 pm
Syed Jahanzaib Bin hassan (7/1/2011)
For In Raid 10
==========
Drive 1 : Data-Files
Drive 2 : Log -...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 3, 2011 at 7:26 pm
It is possible that it is taking a long time to recover because you have a large transaction log - with a lot of active VLF's.
How large is your transaction...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 3, 2011 at 9:34 am
Viewing 15 posts - 3,091 through 3,105 (of 6,676 total)