Excel Import: attached

After enabling AWE in SQL I am noticing a good bit more paging than
before. The attached jpg file is a graph of memory usage.
The configuration for this server is:
IBM x360 w/ 4 x 1.6ghz processors, 8GB memory
Storage: C: and D: partitions internal drives
Data stored on SAN volumes: 5 x 683GB volumes
# databases on this server: 162
boot.ini file has the /3GB and /PAE switches
OS sees all 8GB of memory.
SQL Server has AWE enabled with memory settings:
Min: 0 Max: 5500
As soon as I enabled AWE in SQL, I noticed the following:
(see jpg of the memory usage graph)
1. MemPhysUsage jumps up to almost 80%
(this is the 5500 mark) (in green)
2. PageFileUsage starts climbing up over time. (in pink)
There was little or no page file usage prior to enabling AWE.
Any ideas?
Thanks in advance
jtw
--
http://www.UsenetRocket.comHi,
if the server is only a MS SQL 2k Server, change the
Server properties - dynamicly configure SQL Server Memory -
Give the Server the maximum of memory.
J.K
>--Original Message--
>After enabling AWE in SQL I am noticing a good bit more
paging than
>before. The attached jpg file is a graph of memory usage.
>The configuration for this server is:
>IBM x360 w/ 4 x 1.6ghz processors, 8GB memory
>Storage: C: and D: partitions internal drives
>Data stored on SAN volumes: 5 x 683GB volumes
># databases on this server: 162
>boot.ini file has the /3GB and /PAE switches
>OS sees all 8GB of memory.
>SQL Server has AWE enabled with memory settings:
> Min: 0 Max: 5500
>As soon as I enabled AWE in SQL, I noticed the following:
>(see jpg of the memory usage graph)
>1. MemPhysUsage jumps up to almost 80%
> (this is the 5500 mark) (in green)
>2. PageFileUsage starts climbing up over time. (in pink)
>There was little or no page file usage prior to enabling
AWE.
>Any ideas?
>
>Thanks in advance
>jtw
>--
>http://www.UsenetRocket.com
>.
>

I'm still having some issues with report names using "german umlaute".
Attached two small dataless sample reports, originally named "Ärger.rdl" and
"Übersicht.rdl". Both consists of a textbox linking to each other. Tis works
fine and is displayed correctly in HTML. Exporting one report to Excel and
trying to follow the link fails.
Should I avoid german umlaute in report names? I would consider to do so if
we would have 1982. But not today...:)
r.
Ärger.rdl
--
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<rd:GridSpacing>0.25cm</rd:GridSpacing>
<RightMargin>2.5cm</RightMargin>
<Body>
<ReportItems>
<Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextDecoration>Underline</TextDecoration>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>textbox1</rd:DefaultName>
<Width>6.78968cm</Width>
<Action>
<Drillthrough>
<ReportName>Ãobersicht</ReportName>
</Drillthrough>
</Action>
<CanGrow>true</CanGrow>
<Value>Here is Ã"rger.rdl. Back to Ãobersicht.rdl</Value>
</Textbox>
</ReportItems>
<Style />
<Height>0.63492cm</Height>
<ColumnSpacing>1cm</ColumnSpacing>
</Body>
<TopMargin>2.5cm</TopMargin>
<Width>16cm</Width>
<LeftMargin>2.5cm</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<PageHeight>29.7cm</PageHeight>
<rd:DrawGrid>true</rd:DrawGrid>
<PageWidth>21cm</PageWidth>
<rd:ReportID>52737cce-c0a6-4c5e-b23b-eaeca22bd186</rd:ReportID>
<BottomMargin>2.5cm</BottomMargin>
<Language>de-DE</Language>
</Report>
Übersicht.rdl
--
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<rd:GridSpacing>0.25cm</rd:GridSpacing>
<RightMargin>2.5cm</RightMargin>
<Body>
<ReportItems>
<Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextDecoration>Underline</TextDecoration>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>textbox1</rd:DefaultName>
<Height>0.63492cm</Height>
<Width>7.75cm</Width>
<Action>
<Drillthrough>
<ReportName>Ã"rger</ReportName>
</Drillthrough>
</Action>
<CanGrow>true</CanGrow>
<Value>This way to Ã"rger.rdl</Value>
</Textbox>
</ReportItems>
<Style />
<Height>0.75cm</Height>
<ColumnSpacing>1cm</ColumnSpacing>
</Body>
<TopMargin>2.5cm</TopMargin>
<Width>8cm</Width>
<LeftMargin>2.5cm</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<PageHeight>29.7cm</PageHeight>
<rd:DrawGrid>true</rd:DrawGrid>
<PageWidth>21cm</PageWidth>
<rd:ReportID>b4667abb-f9e5-490e-b3ff-8cca1050a2d1</rd:ReportID>
<BottomMargin>2.5cm</BottomMargin>
<Language>de-DE</Language>
</Report>Yes, we can reproduce the drillthrough issue and we will look into fixing
it. Unfortunately, it's too late for SP1.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Roland" <nomail@.spamprotect.com> wrote in message
news:OP%23skQWWEHA.2816@.TK2MSFTNGP11.phx.gbl...
> I'm still having some issues with report names using "german umlaute".
> Attached two small dataless sample reports, originally named "Ärger.rdl"
and
> "Übersicht.rdl". Both consists of a textbox linking to each other. Tis
works
> fine and is displayed correctly in HTML. Exporting one report to Excel and
> trying to follow the link fails.
> Should I avoid german umlaute in report names? I would consider to do so
if
> we would have 1982. But not today...:)
> r.
>
> Ärger.rdl
> --
> <?xml version="1.0" encoding="utf-8"?>
> <Report
>
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
> tion"
>
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> <rd:GridSpacing>0.25cm</rd:GridSpacing>
> <RightMargin>2.5cm</RightMargin>
> <Body>
> <ReportItems>
> <Textbox Name="textbox1">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <TextDecoration>Underline</TextDecoration>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <rd:DefaultName>textbox1</rd:DefaultName>
> <Width>6.78968cm</Width>
> <Action>
> <Drillthrough>
> <ReportName>Ãobersicht</ReportName>
> </Drillthrough>
> </Action>
> <CanGrow>true</CanGrow>
> <Value>Here is Ã"rger.rdl. Back to Ãobersicht.rdl</Value>
> </Textbox>
> </ReportItems>
> <Style />
> <Height>0.63492cm</Height>
> <ColumnSpacing>1cm</ColumnSpacing>
> </Body>
> <TopMargin>2.5cm</TopMargin>
> <Width>16cm</Width>
> <LeftMargin>2.5cm</LeftMargin>
> <rd:SnapToGrid>true</rd:SnapToGrid>
> <PageHeight>29.7cm</PageHeight>
> <rd:DrawGrid>true</rd:DrawGrid>
> <PageWidth>21cm</PageWidth>
> <rd:ReportID>52737cce-c0a6-4c5e-b23b-eaeca22bd186</rd:ReportID>
> <BottomMargin>2.5cm</BottomMargin>
> <Language>de-DE</Language>
> </Report>
>
> Übersicht.rdl
> --
> <?xml version="1.0" encoding="utf-8"?>
> <Report
>
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
> tion"
>
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> <rd:GridSpacing>0.25cm</rd:GridSpacing>
> <RightMargin>2.5cm</RightMargin>
> <Body>
> <ReportItems>
> <Textbox Name="textbox1">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <TextDecoration>Underline</TextDecoration>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <rd:DefaultName>textbox1</rd:DefaultName>
> <Height>0.63492cm</Height>
> <Width>7.75cm</Width>
> <Action>
> <Drillthrough>
> <ReportName>Ã"rger</ReportName>
> </Drillthrough>
> </Action>
> <CanGrow>true</CanGrow>
> <Value>This way to Ã"rger.rdl</Value>
> </Textbox>
> </ReportItems>
> <Style />
> <Height>0.75cm</Height>
> <ColumnSpacing>1cm</ColumnSpacing>
> </Body>
> <TopMargin>2.5cm</TopMargin>
> <Width>8cm</Width>
> <LeftMargin>2.5cm</LeftMargin>
> <rd:SnapToGrid>true</rd:SnapToGrid>
> <PageHeight>29.7cm</PageHeight>
> <rd:DrawGrid>true</rd:DrawGrid>
> <PageWidth>21cm</PageWidth>
> <rd:ReportID>b4667abb-f9e5-490e-b3ff-8cca1050a2d1</rd:ReportID>
> <BottomMargin>2.5cm</BottomMargin>
> <Language>de-DE</Language>
> </Report>
>
>|||Great, Robert. I'll be patient. Meanwhile I'll rename my reports.
Thanks.
r.

Monday, March 12, 2012

Excessive paging after enabling AWE in SQL server - memgraph1.jpg (0/1)

Wednesday, February 15, 2012

Excel import and german umlaute

Excel Import

Blog Archive

About Me