|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
16GB memory for SQL
Hello
we are having SQL 2000 in cluster mode in HP DL580 with 16GB memory, how to enable 16GB for SQL? any idea? Regards Gopi
http://support.microsoft.com/kb/274750
--
Show quote
Hide quote
Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Gopi" <gopi***@gmail.com> wrote in message
news:u4BrNk2WJHA.1268@TK2MSFTNGP04.phx.gbl... > Hello > > we are having SQL 2000 in cluster mode in HP DL580 with 16GB memory, > how to enable 16GB for SQL? any idea? > > Regards > Gopi > Thanks Tibor
but SQL not taking more than 2GB, any idea? Regards Gopi Show quoteHide quote "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message news:uEl8os2WJHA.4280@TK2MSFTNGP02.phx.gbl... > http://support.microsoft.com/kb/274750 > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://sqlblog.com/blogs/tibor_karaszi > > > "Gopi" <gopi***@gmail.com> wrote in message > news:u4BrNk2WJHA.1268@TK2MSFTNGP04.phx.gbl... >> Hello >> >> we are having SQL 2000 in cluster mode in HP DL580 with 16GB memory, how >> to enable 16GB for SQL? any idea? >> >> Regards >> Gopi >> > > Assuming you did every thing that is required:
Enterprise Edition of SQL Server and an OS that supports PAE PAE in BOOT.INI AWE in SQL Server Proper max server memory Lock pages in memory for service account Verify memory usage the right way (not task manager) And you still not see > 2GB, I suggest you open a case with MS Support. -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Gopi" <gopi***@gmail.com> wrote in message news:uzmRAJDXJHA.4560@TK2MSFTNGP02.phx.gbl... > Thanks Tibor > > but SQL not taking more than 2GB, any idea? > > Regards > Gopi > > "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> > wrote in message news:uEl8os2WJHA.4280@TK2MSFTNGP02.phx.gbl... >> http://support.microsoft.com/kb/274750 >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://sqlblog.com/blogs/tibor_karaszi >> >> >> "Gopi" <gopi***@gmail.com> wrote in message >> news:u4BrNk2WJHA.1268@TK2MSFTNGP04.phx.gbl... >>> Hello >>> >>> we are having SQL 2000 in cluster mode in HP DL580 with 16GB >>> memory, how to enable 16GB for SQL? any idea? >>> >>> Regards >>> Gopi >>> >> >> > >  
Other interesting topics
Access 2000 or 2003 project - can it connect to sql server 2008?
How to look for values in a table SQL2005 spaces in T-SQL An error occurred during the execution of xp_cmdshell. A call to 'CreateProcessAsUser' failed with e the alert couldn't send an email Downloading Query Analyzer? performance question - high cpu usage Running Total i3 symantec tools for sql server Creating a job |
|||||||||||||||||||||||
