Situation:
OS: 2000 advanced server
SQL enterprise
We have just added an extra 6GB of memory to our database server which
brings the total to 8. The problem we are having is that the OS is only using
3Gb of memory.
We have run the SP that is recommended for AWE and entered the /3GB /PAE in
the boot.ini file and restarted the machine.
The server still refuses to use more than 3GB. Any ideas?
Did you re-configure SQL, the AWE and fixed memory?
e.g.
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'min server memory', 6656 (make same as maximum)
RECONFIGURE
go
sp_configure 'max server memory', 6656 (leave at least 512 for the OS)
RECONFIGURE
Regards
Mike
"lramsdale" wrote:
> Situation:
> OS: 2000 advanced server
> SQL enterprise
> We have just added an extra 6GB of memory to our database server which
> brings the total to 8. The problem we are having is that the OS is only using
> 3Gb of memory.
> We have run the SP that is recommended for AWE and entered the /3GB /PAE in
> the boot.ini file and restarted the machine.
> The server still refuses to use more than 3GB. Any ideas?
|||This is what we ran:
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Did you re-configure SQL, the AWE and fixed memory?
> e.g.
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'min server memory', 6656 (make same as maximum)
> RECONFIGURE
> go
> sp_configure 'max server memory', 6656 (leave at least 512 for the OS)
> RECONFIGURE
> Regards
> Mike
> "lramsdale" wrote:
|||Ok we finally got to the bottom of this problem - it seems that we needed to
give the SQL server service account permissions to the lock pages in memory
privelege, even though it was in the domain admin account. This was hard to
find, why is there so much conflicting documentation on this AWE setting?
"lramsdale" wrote:
[vbcol=seagreen]
> This is what we ran:
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> "Mike Epprecht (SQL MVP)" wrote:
Showing posts with label extra. Show all posts
Showing posts with label extra. Show all posts
Monday, March 19, 2012
8GB memory installation
Situation:
OS: 2000 advanced server
SQL enterprise
We have just added an extra 6GB of memory to our database server which
brings the total to 8. The problem we are having is that the OS is only usin
g
3Gb of memory.
We have run the SP that is recommended for AWE and entered the /3GB /PAE in
the boot.ini file and restarted the machine.
The server still refuses to use more than 3GB. Any ideas?Did you re-configure SQL, the AWE and fixed memory?
e.g.
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'min server memory', 6656 (make same as maximum)
RECONFIGURE
go
sp_configure 'max server memory', 6656 (leave at least 512 for the OS)
RECONFIGURE
Regards
Mike
"lramsdale" wrote:
> Situation:
> OS: 2000 advanced server
> SQL enterprise
> We have just added an extra 6GB of memory to our database server which
> brings the total to 8. The problem we are having is that the OS is only us
ing
> 3Gb of memory.
> We have run the SP that is recommended for AWE and entered the /3GB /PAE i
n
> the boot.ini file and restarted the machine.
> The server still refuses to use more than 3GB. Any ideas?|||This is what we ran:
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Did you re-configure SQL, the AWE and fixed memory?
> e.g.
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'min server memory', 6656 (make same as maximum)
> RECONFIGURE
> go
> sp_configure 'max server memory', 6656 (leave at least 512 for the OS)
> RECONFIGURE
> Regards
> Mike
> "lramsdale" wrote:
>|||Ok we finally got to the bottom of this problem - it seems that we needed to
give the SQL server service account permissions to the lock pages in memory
privelege, even though it was in the domain admin account. This was hard to
find, why is there so much conflicting documentation on this AWE setting?
"lramsdale" wrote:
[vbcol=seagreen]
> This is what we ran:
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> "Mike Epprecht (SQL MVP)" wrote:
>
OS: 2000 advanced server
SQL enterprise
We have just added an extra 6GB of memory to our database server which
brings the total to 8. The problem we are having is that the OS is only usin
g
3Gb of memory.
We have run the SP that is recommended for AWE and entered the /3GB /PAE in
the boot.ini file and restarted the machine.
The server still refuses to use more than 3GB. Any ideas?Did you re-configure SQL, the AWE and fixed memory?
e.g.
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'min server memory', 6656 (make same as maximum)
RECONFIGURE
go
sp_configure 'max server memory', 6656 (leave at least 512 for the OS)
RECONFIGURE
Regards
Mike
"lramsdale" wrote:
> Situation:
> OS: 2000 advanced server
> SQL enterprise
> We have just added an extra 6GB of memory to our database server which
> brings the total to 8. The problem we are having is that the OS is only us
ing
> 3Gb of memory.
> We have run the SP that is recommended for AWE and entered the /3GB /PAE i
n
> the boot.ini file and restarted the machine.
> The server still refuses to use more than 3GB. Any ideas?|||This is what we ran:
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Did you re-configure SQL, the AWE and fixed memory?
> e.g.
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'min server memory', 6656 (make same as maximum)
> RECONFIGURE
> go
> sp_configure 'max server memory', 6656 (leave at least 512 for the OS)
> RECONFIGURE
> Regards
> Mike
> "lramsdale" wrote:
>|||Ok we finally got to the bottom of this problem - it seems that we needed to
give the SQL server service account permissions to the lock pages in memory
privelege, even though it was in the domain admin account. This was hard to
find, why is there so much conflicting documentation on this AWE setting?
"lramsdale" wrote:
[vbcol=seagreen]
> This is what we ran:
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> "Mike Epprecht (SQL MVP)" wrote:
>
8GB memory installation
Situation:
OS: 2000 advanced server
SQL enterprise
We have just added an extra 6GB of memory to our database server which
brings the total to 8. The problem we are having is that the OS is only using
3Gb of memory.
We have run the SP that is recommended for AWE and entered the /3GB /PAE in
the boot.ini file and restarted the machine.
The server still refuses to use more than 3GB. Any ideas?Did you re-configure SQL, the AWE and fixed memory?
e.g.
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'min server memory', 6656 (make same as maximum)
RECONFIGURE
go
sp_configure 'max server memory', 6656 (leave at least 512 for the OS)
RECONFIGURE
Regards
Mike
"lramsdale" wrote:
> Situation:
> OS: 2000 advanced server
> SQL enterprise
> We have just added an extra 6GB of memory to our database server which
> brings the total to 8. The problem we are having is that the OS is only using
> 3Gb of memory.
> We have run the SP that is recommended for AWE and entered the /3GB /PAE in
> the boot.ini file and restarted the machine.
> The server still refuses to use more than 3GB. Any ideas?|||This is what we ran:
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
"Mike Epprecht (SQL MVP)" wrote:
> Did you re-configure SQL, the AWE and fixed memory?
> e.g.
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'min server memory', 6656 (make same as maximum)
> RECONFIGURE
> go
> sp_configure 'max server memory', 6656 (leave at least 512 for the OS)
> RECONFIGURE
> Regards
> Mike
> "lramsdale" wrote:
> > Situation:
> >
> > OS: 2000 advanced server
> > SQL enterprise
> >
> > We have just added an extra 6GB of memory to our database server which
> > brings the total to 8. The problem we are having is that the OS is only using
> > 3Gb of memory.
> >
> > We have run the SP that is recommended for AWE and entered the /3GB /PAE in
> > the boot.ini file and restarted the machine.
> >
> > The server still refuses to use more than 3GB. Any ideas?|||Ok we finally got to the bottom of this problem - it seems that we needed to
give the SQL server service account permissions to the lock pages in memory
privelege, even though it was in the domain admin account. This was hard to
find, why is there so much conflicting documentation on this AWE setting?
"lramsdale" wrote:
> This is what we ran:
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> "Mike Epprecht (SQL MVP)" wrote:
> > Did you re-configure SQL, the AWE and fixed memory?
> >
> > e.g.
> >
> > sp_configure 'show advanced options', 1
> > RECONFIGURE
> > GO
> > sp_configure 'awe enabled', 1
> > RECONFIGURE
> > GO
> > sp_configure 'min server memory', 6656 (make same as maximum)
> > RECONFIGURE
> > go
> > sp_configure 'max server memory', 6656 (leave at least 512 for the OS)
> > RECONFIGURE
> >
> > Regards
> > Mike
> >
> > "lramsdale" wrote:
> >
> > > Situation:
> > >
> > > OS: 2000 advanced server
> > > SQL enterprise
> > >
> > > We have just added an extra 6GB of memory to our database server which
> > > brings the total to 8. The problem we are having is that the OS is only using
> > > 3Gb of memory.
> > >
> > > We have run the SP that is recommended for AWE and entered the /3GB /PAE in
> > > the boot.ini file and restarted the machine.
> > >
> > > The server still refuses to use more than 3GB. Any ideas?
OS: 2000 advanced server
SQL enterprise
We have just added an extra 6GB of memory to our database server which
brings the total to 8. The problem we are having is that the OS is only using
3Gb of memory.
We have run the SP that is recommended for AWE and entered the /3GB /PAE in
the boot.ini file and restarted the machine.
The server still refuses to use more than 3GB. Any ideas?Did you re-configure SQL, the AWE and fixed memory?
e.g.
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'min server memory', 6656 (make same as maximum)
RECONFIGURE
go
sp_configure 'max server memory', 6656 (leave at least 512 for the OS)
RECONFIGURE
Regards
Mike
"lramsdale" wrote:
> Situation:
> OS: 2000 advanced server
> SQL enterprise
> We have just added an extra 6GB of memory to our database server which
> brings the total to 8. The problem we are having is that the OS is only using
> 3Gb of memory.
> We have run the SP that is recommended for AWE and entered the /3GB /PAE in
> the boot.ini file and restarted the machine.
> The server still refuses to use more than 3GB. Any ideas?|||This is what we ran:
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
"Mike Epprecht (SQL MVP)" wrote:
> Did you re-configure SQL, the AWE and fixed memory?
> e.g.
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'min server memory', 6656 (make same as maximum)
> RECONFIGURE
> go
> sp_configure 'max server memory', 6656 (leave at least 512 for the OS)
> RECONFIGURE
> Regards
> Mike
> "lramsdale" wrote:
> > Situation:
> >
> > OS: 2000 advanced server
> > SQL enterprise
> >
> > We have just added an extra 6GB of memory to our database server which
> > brings the total to 8. The problem we are having is that the OS is only using
> > 3Gb of memory.
> >
> > We have run the SP that is recommended for AWE and entered the /3GB /PAE in
> > the boot.ini file and restarted the machine.
> >
> > The server still refuses to use more than 3GB. Any ideas?|||Ok we finally got to the bottom of this problem - it seems that we needed to
give the SQL server service account permissions to the lock pages in memory
privelege, even though it was in the domain admin account. This was hard to
find, why is there so much conflicting documentation on this AWE setting?
"lramsdale" wrote:
> This is what we ran:
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> "Mike Epprecht (SQL MVP)" wrote:
> > Did you re-configure SQL, the AWE and fixed memory?
> >
> > e.g.
> >
> > sp_configure 'show advanced options', 1
> > RECONFIGURE
> > GO
> > sp_configure 'awe enabled', 1
> > RECONFIGURE
> > GO
> > sp_configure 'min server memory', 6656 (make same as maximum)
> > RECONFIGURE
> > go
> > sp_configure 'max server memory', 6656 (leave at least 512 for the OS)
> > RECONFIGURE
> >
> > Regards
> > Mike
> >
> > "lramsdale" wrote:
> >
> > > Situation:
> > >
> > > OS: 2000 advanced server
> > > SQL enterprise
> > >
> > > We have just added an extra 6GB of memory to our database server which
> > > brings the total to 8. The problem we are having is that the OS is only using
> > > 3Gb of memory.
> > >
> > > We have run the SP that is recommended for AWE and entered the /3GB /PAE in
> > > the boot.ini file and restarted the machine.
> > >
> > > The server still refuses to use more than 3GB. Any ideas?
Sunday, March 11, 2012
8.5x11.0 Landscape reports insert extra page?
I can't seem to get a landscape report to render properly no matter what I try. It always inserts an extra page between each page of data. The report is sized to 10.5 x 7.00. If I remove portions of the report and resize to 8.0x10.5 it prints fine.
Anybody have any ideas on this?Are you talking render on the web page or when you export?
I had this issue with export to PDF or TIFF and I have to
make the page width > 12 to get it to work correctly.
>--Original Message--
>I can't seem to get a landscape report to render properly
no matter what I try. It always inserts an extra page
between each page of data. The report is sized to 10.5 x
7.00. If I remove portions of the report and resize to
8.0x10.5 it prints fine.
>Anybody have any ideas on this?
>.
>
Anybody have any ideas on this?Are you talking render on the web page or when you export?
I had this issue with export to PDF or TIFF and I have to
make the page width > 12 to get it to work correctly.
>--Original Message--
>I can't seem to get a landscape report to render properly
no matter what I try. It always inserts an extra page
between each page of data. The report is sized to 10.5 x
7.00. If I remove portions of the report and resize to
8.0x10.5 it prints fine.
>Anybody have any ideas on this?
>.
>
Subscribe to:
Posts (Atom)