Viewing 15 posts - 9,091 through 9,105 (of 9,241 total)
jim.powers (7/28/2008)
If that switch is not already there, it does need to be added.
on the very rare odd occasion and normally for older processor architecture. 99% of the time the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2008 at 12:53 pm
george sibbald (7/28/2008)
what Perry and Terry (great name for a double act)
not a s good as Kevin and Perry,, yes mrs patterson 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2008 at 7:02 am
are we talking 1 instance of sql server??
what are min and max memory set to on instance properties?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2008 at 6:34 am
on SQL2005 queries that try to update the system catalogs will be rejected anyway 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2008 at 6:32 am
Milton Gonsalves (7/25/2008)
So only Enabling /PAE should also help.., right?
if your using win 2003 enterprise it should address all the RAM straight off without editing the boot.ini
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2008 at 6:30 am
alimcitp (7/28/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2008 at 6:21 am
ensure you configure the "lock pages in memory" local security policy for the account SQL runs under. Generally its not recommended to use the /3GB switch for machines with 16GB...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 25, 2008 at 10:01 am
just found the MS kb article, it seems 32 bit SQL2005 std can lock pages its just the 64bit that is an issue
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 24, 2008 at 9:31 am
to specify locations for user databases go into SSMS and right click the registered\connected SQL instance and select properties.
Under database settings you specify the default folder for data files and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2008 at 3:37 pm
this is the MS description
this explains it too
http://technet.microsoft.com/en-us/library/ms190730.aspx
basically without it set memory can be paged to disk which will cause huge problems for the running SQL instance. Its important to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2008 at 3:31 pm
clustering is a windows server feature and not windows xp. However, using Microsoft VirtualServer you can on a laptop that is powerful enough set up a virtual 2 node MSCS...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2008 at 3:13 pm
using terminal services in application mode would ideal for remote users, the processing is all done on the terminal server which would be on the same LAN as the database....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2008 at 3:09 pm
Jason Shadonix (7/23/2008)
Msg 3101, Level 16, State 1, Line 2
Exclusive access could not be obtained because the database is in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2008 at 10:56 am
sorry my bad!!
restore database DBNAME with recovery
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2008 at 10:31 am
re run the SQL installer it should pick up any instances already on the pc, then run repair
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2008 at 9:18 am
Viewing 15 posts - 9,091 through 9,105 (of 9,241 total)