Viewing 15 posts - 8,611 through 8,625 (of 9,241 total)
GilaMonster (12/19/2008)
Perry Whittle (12/19/2008)
assuming it is released quick enough
Sure, but the chances of the OS coming under sudden , extreme memory pressure on a dedicated SQL server machine are slim,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 20, 2008 at 11:26 am
assuming it is released quick enough
this link explains the pros and cons
http://support.microsoft.com/kb/918483
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 19, 2008 at 6:58 am
no, in the DNS snap in right click and add server. You should then see both DNS servers, expand and look at the zone setups
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 19, 2008 at 6:44 am
just a small gotcha for this. If the OS is pressured and cant free memory it could bring the server to a halt. I prefer to start low and work...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 19, 2008 at 6:30 am
open the DNS snap in and add each of the DNS servers in then check the zone configs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 19, 2008 at 6:24 am
open the DNS snap in and add each of the DNS servers in then check the zone configs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 19, 2008 at 6:24 am
Mani
i would start with 11GB RAM for SQL and the rest for the OS. Monitor the server and check the memory usage\requirements, adjust as necessary
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 19, 2008 at 2:40 am
firstly have you removed DNS from the terminal server?
have you installed DNS on DC2?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2008 at 5:15 pm
Mani (12/18/2008)
We have windows 2003 EE R2 x64 with SP2 and SQL Server 2005 EE x64 with SP2.
We have 16GB RAM.In Our SQL Server instance sharepoint Application databases are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2008 at 5:11 pm
well, depending on where you read. MSDN states that AWE is only available for 32bit Ent and Dev sql2005. Technet states AWE available for Std, Ent and Dev. This has...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2008 at 5:09 pm
if you're not sure what it does why use it. What version is your OS and SQL instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2008 at 2:18 pm
phew, not a pork chop in sight LOL
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2008 at 10:45 am
set up a server side trace using the following
SP_TRACE_CREATE
SP_TRACE_SETEVENT
SP_TRACE_SETFILTER
SP_TRACE_SETSTATUS
also the functions
fn_trace_gettable
fn_trace_getinfo
to generate a trace definition use the following syntax
declare @traceidout int
declare @maxfilesize bigint
declare @on bit
set @on = 1
set @maxfilesize =...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2008 at 10:32 am
bit difficult to understand when i dont see what you see, are you able to send a screenshot of what you see in DNS MMC?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2008 at 6:07 am
which user have you logged on as on the other machine. Access denied is the key message here
Your code really wants to be expanded as you are only checking for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2008 at 4:26 am
Viewing 15 posts - 8,611 through 8,625 (of 9,241 total)