I think that the SQL Query Analyzer and its successor in SQL2005 suck.
They provide no intellisense whatsoever and it just feels like Notepad
with an Execute button. Anyway, what are the SQL editor alternatives
that people here use? Preferably not more expensive than $400.
Thanks.
Well, if you want intellisense perhaps you should check out PromptSQL:
http://www.promptsql.com/
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"Frank Rizzo" <none@.none.com> wrote in message
news:eb9mCf84FHA.2404@.TK2MSFTNGP12.phx.gbl...
>I think that the SQL Query Analyzer and its successor in SQL2005 suck. They
>provide no intellisense whatsoever and it just feels like Notepad with an
>Execute button. Anyway, what are the SQL editor alternatives that people
>here use? Preferably not more expensive than $400.
> Thanks.
|||I use aquadata studio. Very nice, Java, intellisense, support for Oracle,
DB2, SQL Server, etc.
"Adam Machanic" wrote:
> Well, if you want intellisense perhaps you should check out PromptSQL:
> http://www.promptsql.com/
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Frank Rizzo" <none@.none.com> wrote in message
> news:eb9mCf84FHA.2404@.TK2MSFTNGP12.phx.gbl...
>
>
|||Hi Adam, have you had any problems with PromptSQL? The demo seems
pretty good so far. I feel somewhat apprehensive about entering the
login info for my database for it to connect, do you know anything
about the company?
|||Hello Ben,
Atadore, the creator of PromptSQL is a Swiss registered company -- it
will be on the registrar of companies if you need to confirm the owners
etc. Some background about me:
http://www.simple-talk.com/2005/10/2...damian-mehers/
If you contact us via the contact form on our web site I'll be happy to
provide you with any additional information you may need.
Regards,
Damian (author of PromptSQL)
|||Well, it needs to connect somehow to get the information...
The company is just one guy, AFAIK. If you don't trust the product, run it
on a dev server and monitor your network for outgoing traffic. But I
seriously doubt that it's doing anything unauthorized.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"Ben" <vanevery@.gmail.com> wrote in message
news:1131477133.786224.217760@.g44g2000cwa.googlegr oups.com...
> Hi Adam, have you had any problems with PromptSQL? The demo seems
> pretty good so far. I feel somewhat apprehensive about entering the
> login info for my database for it to connect, do you know anything
> about the company?
>
|||Adam's blown my cover -- ok so it is just one person ;-)
FWIW PromptSQL makes no use of the network whatsoever. The only file
it accesses is the options XML file.
Regards,
Damian
Showing posts with label sql2005. Show all posts
Showing posts with label sql2005. Show all posts
Tuesday, March 20, 2012
A better SQL editor.
A better SQL editor.
I think that the SQL Query Analyzer and its successor in SQL2005 suck.
They provide no intellisense whatsoever and it just feels like Notepad
with an Execute button. Anyway, what are the SQL editor alternatives
that people here use? Preferably not more expensive than $400.
Thanks.Well, if you want intellisense perhaps you should check out PromptSQL:
http://www.promptsql.com/
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Frank Rizzo" <none@.none.com> wrote in message
news:eb9mCf84FHA.2404@.TK2MSFTNGP12.phx.gbl...
>I think that the SQL Query Analyzer and its successor in SQL2005 suck. They
>provide no intellisense whatsoever and it just feels like Notepad with an
>Execute button. Anyway, what are the SQL editor alternatives that people
>here use? Preferably not more expensive than $400.
> Thanks.|||I use aquadata studio. Very nice, Java, intellisense, support for Oracle,
DB2, SQL Server, etc.
"Adam Machanic" wrote:
> Well, if you want intellisense perhaps you should check out PromptSQL:
> http://www.promptsql.com/
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Frank Rizzo" <none@.none.com> wrote in message
> news:eb9mCf84FHA.2404@.TK2MSFTNGP12.phx.gbl...
>
>|||Hi Adam, have you had any problems with PromptSQL? The demo seems
pretty good so far. I feel somewhat apprehensive about entering the
login info for my database for it to connect, do you know anything
about the company?|||Hello Ben,
Atadore, the creator of PromptSQL is a Swiss registered company -- it
will be on the registrar of companies if you need to confirm the owners
etc. Some background about me:
[url]http://www.simple-talk.com/2005/10/26/database-geek-of-the-week-damian-mehers/[/ur
l]
If you contact us via the contact form on our web site I'll be happy to
provide you with any additional information you may need.
Regards,
Damian (author of PromptSQL)|||Well, it needs to connect somehow to get the information...
The company is just one guy, AFAIK. If you don't trust the product, run it
on a dev server and monitor your network for outgoing traffic. But I
seriously doubt that it's doing anything unauthorized.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Ben" <vanevery@.gmail.com> wrote in message
news:1131477133.786224.217760@.g44g2000cwa.googlegroups.com...
> Hi Adam, have you had any problems with PromptSQL? The demo seems
> pretty good so far. I feel somewhat apprehensive about entering the
> login info for my database for it to connect, do you know anything
> about the company?
>|||Adam's blown my cover -- ok so it is just one person ;-)
FWIW PromptSQL makes no use of the network whatsoever. The only file
it accesses is the options XML file.
Regards,
Damian
They provide no intellisense whatsoever and it just feels like Notepad
with an Execute button. Anyway, what are the SQL editor alternatives
that people here use? Preferably not more expensive than $400.
Thanks.Well, if you want intellisense perhaps you should check out PromptSQL:
http://www.promptsql.com/
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Frank Rizzo" <none@.none.com> wrote in message
news:eb9mCf84FHA.2404@.TK2MSFTNGP12.phx.gbl...
>I think that the SQL Query Analyzer and its successor in SQL2005 suck. They
>provide no intellisense whatsoever and it just feels like Notepad with an
>Execute button. Anyway, what are the SQL editor alternatives that people
>here use? Preferably not more expensive than $400.
> Thanks.|||I use aquadata studio. Very nice, Java, intellisense, support for Oracle,
DB2, SQL Server, etc.
"Adam Machanic" wrote:
> Well, if you want intellisense perhaps you should check out PromptSQL:
> http://www.promptsql.com/
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Frank Rizzo" <none@.none.com> wrote in message
> news:eb9mCf84FHA.2404@.TK2MSFTNGP12.phx.gbl...
>
>|||Hi Adam, have you had any problems with PromptSQL? The demo seems
pretty good so far. I feel somewhat apprehensive about entering the
login info for my database for it to connect, do you know anything
about the company?|||Hello Ben,
Atadore, the creator of PromptSQL is a Swiss registered company -- it
will be on the registrar of companies if you need to confirm the owners
etc. Some background about me:
[url]http://www.simple-talk.com/2005/10/26/database-geek-of-the-week-damian-mehers/[/ur
l]
If you contact us via the contact form on our web site I'll be happy to
provide you with any additional information you may need.
Regards,
Damian (author of PromptSQL)|||Well, it needs to connect somehow to get the information...
The company is just one guy, AFAIK. If you don't trust the product, run it
on a dev server and monitor your network for outgoing traffic. But I
seriously doubt that it's doing anything unauthorized.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Ben" <vanevery@.gmail.com> wrote in message
news:1131477133.786224.217760@.g44g2000cwa.googlegroups.com...
> Hi Adam, have you had any problems with PromptSQL? The demo seems
> pretty good so far. I feel somewhat apprehensive about entering the
> login info for my database for it to connect, do you know anything
> about the company?
>|||Adam's blown my cover -- ok so it is just one person ;-)
FWIW PromptSQL makes no use of the network whatsoever. The only file
it accesses is the options XML file.
Regards,
Damian
A better SQL editor.
I think that the SQL Query Analyzer and its successor in SQL2005 suck.
They provide no intellisense whatsoever and it just feels like Notepad
with an Execute button. Anyway, what are the SQL editor alternatives
that people here use? Preferably not more expensive than $400.
Thanks.Well, if you want intellisense perhaps you should check out PromptSQL:
http://www.promptsql.com/
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Frank Rizzo" <none@.none.com> wrote in message
news:eb9mCf84FHA.2404@.TK2MSFTNGP12.phx.gbl...
>I think that the SQL Query Analyzer and its successor in SQL2005 suck. They
>provide no intellisense whatsoever and it just feels like Notepad with an
>Execute button. Anyway, what are the SQL editor alternatives that people
>here use? Preferably not more expensive than $400.
> Thanks.|||I use aquadata studio. Very nice, Java, intellisense, support for Oracle,
DB2, SQL Server, etc.
"Adam Machanic" wrote:
> Well, if you want intellisense perhaps you should check out PromptSQL:
> http://www.promptsql.com/
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Frank Rizzo" <none@.none.com> wrote in message
> news:eb9mCf84FHA.2404@.TK2MSFTNGP12.phx.gbl...
> >I think that the SQL Query Analyzer and its successor in SQL2005 suck. They
> >provide no intellisense whatsoever and it just feels like Notepad with an
> >Execute button. Anyway, what are the SQL editor alternatives that people
> >here use? Preferably not more expensive than $400.
> >
> > Thanks.
>
>|||Hi Adam, have you had any problems with PromptSQL? The demo seems
pretty good so far. I feel somewhat apprehensive about entering the
login info for my database for it to connect, do you know anything
about the company?|||Hello Ben,
Atadore, the creator of PromptSQL is a Swiss registered company -- it
will be on the registrar of companies if you need to confirm the owners
etc. Some background about me:
http://www.simple-talk.com/2005/10/26/database-geek-of-the-week-damian-mehers/
If you contact us via the contact form on our web site I'll be happy to
provide you with any additional information you may need.
Regards,
Damian (author of PromptSQL)|||Well, it needs to connect somehow to get the information...
The company is just one guy, AFAIK. If you don't trust the product, run it
on a dev server and monitor your network for outgoing traffic. But I
seriously doubt that it's doing anything unauthorized.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Ben" <vanevery@.gmail.com> wrote in message
news:1131477133.786224.217760@.g44g2000cwa.googlegroups.com...
> Hi Adam, have you had any problems with PromptSQL? The demo seems
> pretty good so far. I feel somewhat apprehensive about entering the
> login info for my database for it to connect, do you know anything
> about the company?
>|||Adam's blown my cover -- ok so it is just one person ;-)
FWIW PromptSQL makes no use of the network whatsoever. The only file
it accesses is the options XML file.
Regards,
Damian
They provide no intellisense whatsoever and it just feels like Notepad
with an Execute button. Anyway, what are the SQL editor alternatives
that people here use? Preferably not more expensive than $400.
Thanks.Well, if you want intellisense perhaps you should check out PromptSQL:
http://www.promptsql.com/
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Frank Rizzo" <none@.none.com> wrote in message
news:eb9mCf84FHA.2404@.TK2MSFTNGP12.phx.gbl...
>I think that the SQL Query Analyzer and its successor in SQL2005 suck. They
>provide no intellisense whatsoever and it just feels like Notepad with an
>Execute button. Anyway, what are the SQL editor alternatives that people
>here use? Preferably not more expensive than $400.
> Thanks.|||I use aquadata studio. Very nice, Java, intellisense, support for Oracle,
DB2, SQL Server, etc.
"Adam Machanic" wrote:
> Well, if you want intellisense perhaps you should check out PromptSQL:
> http://www.promptsql.com/
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Frank Rizzo" <none@.none.com> wrote in message
> news:eb9mCf84FHA.2404@.TK2MSFTNGP12.phx.gbl...
> >I think that the SQL Query Analyzer and its successor in SQL2005 suck. They
> >provide no intellisense whatsoever and it just feels like Notepad with an
> >Execute button. Anyway, what are the SQL editor alternatives that people
> >here use? Preferably not more expensive than $400.
> >
> > Thanks.
>
>|||Hi Adam, have you had any problems with PromptSQL? The demo seems
pretty good so far. I feel somewhat apprehensive about entering the
login info for my database for it to connect, do you know anything
about the company?|||Hello Ben,
Atadore, the creator of PromptSQL is a Swiss registered company -- it
will be on the registrar of companies if you need to confirm the owners
etc. Some background about me:
http://www.simple-talk.com/2005/10/26/database-geek-of-the-week-damian-mehers/
If you contact us via the contact form on our web site I'll be happy to
provide you with any additional information you may need.
Regards,
Damian (author of PromptSQL)|||Well, it needs to connect somehow to get the information...
The company is just one guy, AFAIK. If you don't trust the product, run it
on a dev server and monitor your network for outgoing traffic. But I
seriously doubt that it's doing anything unauthorized.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Ben" <vanevery@.gmail.com> wrote in message
news:1131477133.786224.217760@.g44g2000cwa.googlegroups.com...
> Hi Adam, have you had any problems with PromptSQL? The demo seems
> pretty good so far. I feel somewhat apprehensive about entering the
> login info for my database for it to connect, do you know anything
> about the company?
>|||Adam's blown my cover -- ok so it is just one person ;-)
FWIW PromptSQL makes no use of the network whatsoever. The only file
it accesses is the options XML file.
Regards,
Damian
Monday, February 13, 2012
401: Unauthorized.
Dear all,
I have 2 server, Server_A is IIS, Server_B is Reporting Server(SQL2005).
I create a web project under Server_A and drop a reportviewer on the
default.aspx.
I then enter the Server URL and Report path. And build the project.
I can then browse the report without any problem if URL is typing
localhost/web_project/default.aspx
But problem comes up if change into Server_A/webproject/default.aspx.
The message is
The request failed with HTTP status 401: Unauthorized.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Net.WebException: The request failed with HTTP
status 401: Unauthorized.
Regards,
Ken Linhai
this ragu
u have iis server security problem u verify ur admin
i have the same problem occur i verify my admin
i sent the coading
private void button1_Click_1(object sender, EventArgs e)
{
RunRemote();
}
private void RunRemote()
{
try
{
// this.Cursor = Cursors.WaitCursor;
reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
reportViewer1.ServerReport.ReportServerUrl = new Uri(Settings.Default.ReportServerEndPoint);
reportViewer1.ServerReport.ReportPath = "/Report Project3/TestReortForFunds";
reportViewer1.RefreshReport();
}
catch (Exception ex)
{
throw ex;
}
finally
{
//this.Cursor = Cursors.Default;
}
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com|||use this code easily retrive your report
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportPath = "/Report Project3/TestReortForFunds";
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ConfigurationManager.AppSettings["ReportServerEndPoint"]);
Microsoft.Reporting.WebForms.ReportParameter [1]=new Microsoft.Reporting.WebForms.ReportParameter (0);
}
}
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com|||No, I can sucess to view the report from the IE in Web Server.
But when I go to toher computers, got the 401 error.
Regards,
Ken Lin
<ragu> wrote in message news:2006122114446ragu1100@.yahoo.com...
> use this code easily retrive your report
>
> protected void Page_Load(object sender, EventArgs e)
> {
>
> if (!Page.IsPostBack)
> {
> ReportViewer1.ProcessingMode => Microsoft.Reporting.WebForms.ProcessingMode.Remote;
> ReportViewer1.ServerReport.ReportPath = "/Report
> Project3/TestReortForFunds";
> ReportViewer1.ServerReport.ReportServerUrl = new
> Uri(ConfigurationManager.AppSettings["ReportServerEndPoint"]);
> Microsoft.Reporting.WebForms.ReportParameter [1]=new
> Microsoft.Reporting.WebForms.ReportParameter (0);
>
> }
> }
> EggHeadCafe.com - .NET Developer Portal of Choice
> http://www.eggheadcafe.com
I have 2 server, Server_A is IIS, Server_B is Reporting Server(SQL2005).
I create a web project under Server_A and drop a reportviewer on the
default.aspx.
I then enter the Server URL and Report path. And build the project.
I can then browse the report without any problem if URL is typing
localhost/web_project/default.aspx
But problem comes up if change into Server_A/webproject/default.aspx.
The message is
The request failed with HTTP status 401: Unauthorized.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Net.WebException: The request failed with HTTP
status 401: Unauthorized.
Regards,
Ken Linhai
this ragu
u have iis server security problem u verify ur admin
i have the same problem occur i verify my admin
i sent the coading
private void button1_Click_1(object sender, EventArgs e)
{
RunRemote();
}
private void RunRemote()
{
try
{
// this.Cursor = Cursors.WaitCursor;
reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
reportViewer1.ServerReport.ReportServerUrl = new Uri(Settings.Default.ReportServerEndPoint);
reportViewer1.ServerReport.ReportPath = "/Report Project3/TestReortForFunds";
reportViewer1.RefreshReport();
}
catch (Exception ex)
{
throw ex;
}
finally
{
//this.Cursor = Cursors.Default;
}
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com|||use this code easily retrive your report
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportPath = "/Report Project3/TestReortForFunds";
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ConfigurationManager.AppSettings["ReportServerEndPoint"]);
Microsoft.Reporting.WebForms.ReportParameter [1]=new Microsoft.Reporting.WebForms.ReportParameter (0);
}
}
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com|||No, I can sucess to view the report from the IE in Web Server.
But when I go to toher computers, got the 401 error.
Regards,
Ken Lin
<ragu> wrote in message news:2006122114446ragu1100@.yahoo.com...
> use this code easily retrive your report
>
> protected void Page_Load(object sender, EventArgs e)
> {
>
> if (!Page.IsPostBack)
> {
> ReportViewer1.ProcessingMode => Microsoft.Reporting.WebForms.ProcessingMode.Remote;
> ReportViewer1.ServerReport.ReportPath = "/Report
> Project3/TestReortForFunds";
> ReportViewer1.ServerReport.ReportServerUrl = new
> Uri(ConfigurationManager.AppSettings["ReportServerEndPoint"]);
> Microsoft.Reporting.WebForms.ReportParameter [1]=new
> Microsoft.Reporting.WebForms.ReportParameter (0);
>
> }
> }
> EggHeadCafe.com - .NET Developer Portal of Choice
> http://www.eggheadcafe.com
Thursday, February 9, 2012
3gig or 4?
Hey all,
Ok I have a client that currently have 3gig of memory in their SQL
Server (SQL2005).
They are using the /3gb switch in their boot.ini so in theory SQL
server should use greater than 2 gig.
Ok from my understanding, if they put in an extra 1 gig of ram to make
the server now have 4 gig, would this mean that SQL Server would use 3
gig, and the OS 1gig?
So are their any advantages from going from 3gig to 4gig? (would it
help paging for example)
Look forward to your comments
Thanks!Hi,
Read this article..
http://www.sql-server-performance.com/awe_memory.asp
Thanks
Hari
SQL Server MVP
<davconts@.gmail.com> wrote in message
news:1155079279.501553.287040@.i42g2000cwa.googlegroups.com...
> Hey all,
> Ok I have a client that currently have 3gig of memory in their SQL
> Server (SQL2005).
> They are using the /3gb switch in their boot.ini so in theory SQL
> server should use greater than 2 gig.
> Ok from my understanding, if they put in an extra 1 gig of ram to make
> the server now have 4 gig, would this mean that SQL Server would use 3
> gig, and the OS 1gig?
> So are their any advantages from going from 3gig to 4gig? (would it
> help paging for example)
> Look forward to your comments
> Thanks!
>|||That article is not exactly accurate or clear in places. For instance, it
states, "AWE memory technology is used only for the RAM that exceeds the bas
e
4GB of RAM". That is not correct. You can enable AWE with less than 4GB of
RAM.
Linchi
"Hari Prasad" wrote:
> Hi,
> Read this article..
> http://www.sql-server-performance.com/awe_memory.asp
> Thanks
> Hari
> SQL Server MVP
> <davconts@.gmail.com> wrote in message
> news:1155079279.501553.287040@.i42g2000cwa.googlegroups.com...
>
>|||Thanks for the replies.
I read the article but it doesn't really answer my question on whether
it is worth going from 3Gig to 4gig... will SQL server be able to use
that extra gig placed in the machine or will the OS take hold of the
1gig?
Sounds like using AWE will take all the memory (besides 128 meg) unless
a max memory setting is specified in SQL.. so in theory this could
force it to use say 3.5gig of memory.
But the article also suggests not using AWE for a 4gig machine.. so bit
confused now
I assume there would be advantages going from 3 to 4gig... anyone have
any experiences in this?|||Using AWE on a 4GB box just doesn't make much sense.
PAE (/3GB) will use 3 GB for SQL Server, so in a 4 GB box, AWE uses a fair
amount of resources (including memory) to manage the extended memory,
thereby negating most of the expected performance gain.
My experience is that you have to approach 5 GB + before AWE really shows
any gains.
Of course, it could be hardware related and YMMV.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<davconts@.gmail.com> wrote in message
news:1155086938.963563.37190@.m79g2000cwm.googlegroups.com...
> Thanks for the replies.
> I read the article but it doesn't really answer my question on whether
> it is worth going from 3Gig to 4gig... will SQL server be able to use
> that extra gig placed in the machine or will the OS take hold of the
> 1gig?
> Sounds like using AWE will take all the memory (besides 128 meg) unless
> a max memory setting is specified in SQL.. so in theory this could
> force it to use say 3.5gig of memory.
> But the article also suggests not using AWE for a 4gig machine.. so bit
> confused now
> I assume there would be advantages going from 3 to 4gig... anyone have
> any experiences in this?
>|||You have no need to use AWE, there are many disadvantages to using AWE as
well.
To determine if the 3GB switch will allow SQL Server to use more memory can
you tell us what the LEAST amount of free memory you see on the system?
What is that MAX amount of memory you see the SQL Server process consume?
On a side note you might not need to add the additional RAM is your buffer
cache hit ratio is already at 99%+
Paul
<davconts@.gmail.com> wrote in message
news:1155086938.963563.37190@.m79g2000cwm.googlegroups.com...
> Thanks for the replies.
> I read the article but it doesn't really answer my question on whether
> it is worth going from 3Gig to 4gig... will SQL server be able to use
> that extra gig placed in the machine or will the OS take hold of the
> 1gig?
> Sounds like using AWE will take all the memory (besides 128 meg) unless
> a max memory setting is specified in SQL.. so in theory this could
> force it to use say 3.5gig of memory.
> But the article also suggests not using AWE for a 4gig machine.. so bit
> confused now
> I assume there would be advantages going from 3 to 4gig... anyone have
> any experiences in this?
>|||Well we are actually doing a benchmark session tomorrow.
First we are going to run with 3gig of ram, and benchmark our app/db
performance.
Then, we will restart the SQL server with an additional gig of ram (now
4 gig) and compare.
FYI It's a 20gig database. CPU for the server looks adequate from what
I can see (dual xeon). The SQL server only runs SQL 2005, and it is
exclusive to our app.
>From a benchmark we did a month or so ago, I thought the memory usage
seemed ok.
The disks seemed to be a possible bottle neck - and there seemed to be
a fair bit of paging although how much is normal paging I'm not 100%
sure.
I'm hoping that the extra ram might help reduce disk usage/paging.
Oh I should also mention that we are runing raid 10, have the mdf on
d:, ldf file on e: and tempdb on c:\
David
Paul Widner wrote:[vbcol=seagreen]
> You have no need to use AWE, there are many disadvantages to using AWE as
> well.
> To determine if the 3GB switch will allow SQL Server to use more memory ca
n
> you tell us what the LEAST amount of free memory you see on the system?
> What is that MAX amount of memory you see the SQL Server process consume?
> On a side note you might not need to add the additional RAM is your buffer
> cache hit ratio is already at 99%+
> Paul
> <davconts@.gmail.com> wrote in message
> news:1155086938.963563.37190@.m79g2000cwm.googlegroups.com...|||I think that you will find no change or perhaps even a decreased performance
for AWE.
/AWE sets aside 1 GB for the OS AND AWE memory management extensions, and
adds a lot of processing overhead.
With /3GB, the OS still gets 1 GB, but you don't have the AWE overhead.
AWE Net change: Memory about the same, available CPU cycles reduced.
Depending upon the database, number of users, etc., I usually try to have
enough memory so that the majority of active tables are at all times in
cache. Main thing to watch for is memory page I/O. A lot of activity
indicates a need for more memory.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<davconts@.gmail.com> wrote in message
news:1155170138.095989.131980@.m73g2000cwd.googlegroups.com...
> Well we are actually doing a benchmark session tomorrow.
> First we are going to run with 3gig of ram, and benchmark our app/db
> performance.
> Then, we will restart the SQL server with an additional gig of ram (now
> 4 gig) and compare.
> FYI It's a 20gig database. CPU for the server looks adequate from what
> I can see (dual xeon). The SQL server only runs SQL 2005, and it is
> exclusive to our app.
>
> seemed ok.
> The disks seemed to be a possible bottle neck - and there seemed to be
> a fair bit of paging although how much is normal paging I'm not 100%
> sure.
> I'm hoping that the extra ram might help reduce disk usage/paging.
> Oh I should also mention that we are runing raid 10, have the mdf on
> d:, ldf file on e: and tempdb on c:\
> David
>
> Paul Widner wrote:
>
Ok I have a client that currently have 3gig of memory in their SQL
Server (SQL2005).
They are using the /3gb switch in their boot.ini so in theory SQL
server should use greater than 2 gig.
Ok from my understanding, if they put in an extra 1 gig of ram to make
the server now have 4 gig, would this mean that SQL Server would use 3
gig, and the OS 1gig?
So are their any advantages from going from 3gig to 4gig? (would it
help paging for example)
Look forward to your comments
Thanks!Hi,
Read this article..
http://www.sql-server-performance.com/awe_memory.asp
Thanks
Hari
SQL Server MVP
<davconts@.gmail.com> wrote in message
news:1155079279.501553.287040@.i42g2000cwa.googlegroups.com...
> Hey all,
> Ok I have a client that currently have 3gig of memory in their SQL
> Server (SQL2005).
> They are using the /3gb switch in their boot.ini so in theory SQL
> server should use greater than 2 gig.
> Ok from my understanding, if they put in an extra 1 gig of ram to make
> the server now have 4 gig, would this mean that SQL Server would use 3
> gig, and the OS 1gig?
> So are their any advantages from going from 3gig to 4gig? (would it
> help paging for example)
> Look forward to your comments
> Thanks!
>|||That article is not exactly accurate or clear in places. For instance, it
states, "AWE memory technology is used only for the RAM that exceeds the bas
e
4GB of RAM". That is not correct. You can enable AWE with less than 4GB of
RAM.
Linchi
"Hari Prasad" wrote:
> Hi,
> Read this article..
> http://www.sql-server-performance.com/awe_memory.asp
> Thanks
> Hari
> SQL Server MVP
> <davconts@.gmail.com> wrote in message
> news:1155079279.501553.287040@.i42g2000cwa.googlegroups.com...
>
>|||Thanks for the replies.
I read the article but it doesn't really answer my question on whether
it is worth going from 3Gig to 4gig... will SQL server be able to use
that extra gig placed in the machine or will the OS take hold of the
1gig?
Sounds like using AWE will take all the memory (besides 128 meg) unless
a max memory setting is specified in SQL.. so in theory this could
force it to use say 3.5gig of memory.
But the article also suggests not using AWE for a 4gig machine.. so bit
confused now
I assume there would be advantages going from 3 to 4gig... anyone have
any experiences in this?|||Using AWE on a 4GB box just doesn't make much sense.
PAE (/3GB) will use 3 GB for SQL Server, so in a 4 GB box, AWE uses a fair
amount of resources (including memory) to manage the extended memory,
thereby negating most of the expected performance gain.
My experience is that you have to approach 5 GB + before AWE really shows
any gains.
Of course, it could be hardware related and YMMV.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<davconts@.gmail.com> wrote in message
news:1155086938.963563.37190@.m79g2000cwm.googlegroups.com...
> Thanks for the replies.
> I read the article but it doesn't really answer my question on whether
> it is worth going from 3Gig to 4gig... will SQL server be able to use
> that extra gig placed in the machine or will the OS take hold of the
> 1gig?
> Sounds like using AWE will take all the memory (besides 128 meg) unless
> a max memory setting is specified in SQL.. so in theory this could
> force it to use say 3.5gig of memory.
> But the article also suggests not using AWE for a 4gig machine.. so bit
> confused now
> I assume there would be advantages going from 3 to 4gig... anyone have
> any experiences in this?
>|||You have no need to use AWE, there are many disadvantages to using AWE as
well.
To determine if the 3GB switch will allow SQL Server to use more memory can
you tell us what the LEAST amount of free memory you see on the system?
What is that MAX amount of memory you see the SQL Server process consume?
On a side note you might not need to add the additional RAM is your buffer
cache hit ratio is already at 99%+
Paul
<davconts@.gmail.com> wrote in message
news:1155086938.963563.37190@.m79g2000cwm.googlegroups.com...
> Thanks for the replies.
> I read the article but it doesn't really answer my question on whether
> it is worth going from 3Gig to 4gig... will SQL server be able to use
> that extra gig placed in the machine or will the OS take hold of the
> 1gig?
> Sounds like using AWE will take all the memory (besides 128 meg) unless
> a max memory setting is specified in SQL.. so in theory this could
> force it to use say 3.5gig of memory.
> But the article also suggests not using AWE for a 4gig machine.. so bit
> confused now
> I assume there would be advantages going from 3 to 4gig... anyone have
> any experiences in this?
>|||Well we are actually doing a benchmark session tomorrow.
First we are going to run with 3gig of ram, and benchmark our app/db
performance.
Then, we will restart the SQL server with an additional gig of ram (now
4 gig) and compare.
FYI It's a 20gig database. CPU for the server looks adequate from what
I can see (dual xeon). The SQL server only runs SQL 2005, and it is
exclusive to our app.
>From a benchmark we did a month or so ago, I thought the memory usage
seemed ok.
The disks seemed to be a possible bottle neck - and there seemed to be
a fair bit of paging although how much is normal paging I'm not 100%
sure.
I'm hoping that the extra ram might help reduce disk usage/paging.
Oh I should also mention that we are runing raid 10, have the mdf on
d:, ldf file on e: and tempdb on c:\
David
Paul Widner wrote:[vbcol=seagreen]
> You have no need to use AWE, there are many disadvantages to using AWE as
> well.
> To determine if the 3GB switch will allow SQL Server to use more memory ca
n
> you tell us what the LEAST amount of free memory you see on the system?
> What is that MAX amount of memory you see the SQL Server process consume?
> On a side note you might not need to add the additional RAM is your buffer
> cache hit ratio is already at 99%+
> Paul
> <davconts@.gmail.com> wrote in message
> news:1155086938.963563.37190@.m79g2000cwm.googlegroups.com...|||I think that you will find no change or perhaps even a decreased performance
for AWE.
/AWE sets aside 1 GB for the OS AND AWE memory management extensions, and
adds a lot of processing overhead.
With /3GB, the OS still gets 1 GB, but you don't have the AWE overhead.
AWE Net change: Memory about the same, available CPU cycles reduced.
Depending upon the database, number of users, etc., I usually try to have
enough memory so that the majority of active tables are at all times in
cache. Main thing to watch for is memory page I/O. A lot of activity
indicates a need for more memory.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<davconts@.gmail.com> wrote in message
news:1155170138.095989.131980@.m73g2000cwd.googlegroups.com...
> Well we are actually doing a benchmark session tomorrow.
> First we are going to run with 3gig of ram, and benchmark our app/db
> performance.
> Then, we will restart the SQL server with an additional gig of ram (now
> 4 gig) and compare.
> FYI It's a 20gig database. CPU for the server looks adequate from what
> I can see (dual xeon). The SQL server only runs SQL 2005, and it is
> exclusive to our app.
>
> seemed ok.
> The disks seemed to be a possible bottle neck - and there seemed to be
> a fair bit of paging although how much is normal paging I'm not 100%
> sure.
> I'm hoping that the extra ram might help reduce disk usage/paging.
> Oh I should also mention that we are runing raid 10, have the mdf on
> d:, ldf file on e: and tempdb on c:\
> David
>
> Paul Widner wrote:
>
3gig or 4?
Hey all,
Ok I have a client that currently have 3gig of memory in their SQL
Server (SQL2005).
They are using the /3gb switch in their boot.ini so in theory SQL
server should use greater than 2 gig.
Ok from my understanding, if they put in an extra 1 gig of ram to make
the server now have 4 gig, would this mean that SQL Server would use 3
gig, and the OS 1gig?
So are their any advantages from going from 3gig to 4gig? (would it
help paging for example)
Look forward to your comments
Thanks!Hi,
Read this article..
http://www.sql-server-performance.com/awe_memory.asp
Thanks
Hari
SQL Server MVP
<davconts@.gmail.com> wrote in message
news:1155079279.501553.287040@.i42g2000cwa.googlegroups.com...
> Hey all,
> Ok I have a client that currently have 3gig of memory in their SQL
> Server (SQL2005).
> They are using the /3gb switch in their boot.ini so in theory SQL
> server should use greater than 2 gig.
> Ok from my understanding, if they put in an extra 1 gig of ram to make
> the server now have 4 gig, would this mean that SQL Server would use 3
> gig, and the OS 1gig?
> So are their any advantages from going from 3gig to 4gig? (would it
> help paging for example)
> Look forward to your comments
> Thanks!
>|||That article is not exactly accurate or clear in places. For instance, it
states, "AWE memory technology is used only for the RAM that exceeds the base
4GB of RAM". That is not correct. You can enable AWE with less than 4GB of
RAM.
Linchi
"Hari Prasad" wrote:
> Hi,
> Read this article..
> http://www.sql-server-performance.com/awe_memory.asp
> Thanks
> Hari
> SQL Server MVP
> <davconts@.gmail.com> wrote in message
> news:1155079279.501553.287040@.i42g2000cwa.googlegroups.com...
> > Hey all,
> >
> > Ok I have a client that currently have 3gig of memory in their SQL
> > Server (SQL2005).
> >
> > They are using the /3gb switch in their boot.ini so in theory SQL
> > server should use greater than 2 gig.
> >
> > Ok from my understanding, if they put in an extra 1 gig of ram to make
> > the server now have 4 gig, would this mean that SQL Server would use 3
> > gig, and the OS 1gig?
> >
> > So are their any advantages from going from 3gig to 4gig? (would it
> > help paging for example)
> >
> > Look forward to your comments
> >
> > Thanks!
> >
>
>|||Thanks for the replies.
I read the article but it doesn't really answer my question on whether
it is worth going from 3Gig to 4gig... will SQL server be able to use
that extra gig placed in the machine or will the OS take hold of the
1gig?
Sounds like using AWE will take all the memory (besides 128 meg) unless
a max memory setting is specified in SQL.. so in theory this could
force it to use say 3.5gig of memory.
But the article also suggests not using AWE for a 4gig machine.. so bit
confused now :)
I assume there would be advantages going from 3 to 4gig... anyone have
any experiences in this?|||Using AWE on a 4GB box just doesn't make much sense.
PAE (/3GB) will use 3 GB for SQL Server, so in a 4 GB box, AWE uses a fair
amount of resources (including memory) to manage the extended memory,
thereby negating most of the expected performance gain.
My experience is that you have to approach 5 GB + before AWE really shows
any gains.
Of course, it could be hardware related and YMMV.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<davconts@.gmail.com> wrote in message
news:1155086938.963563.37190@.m79g2000cwm.googlegroups.com...
> Thanks for the replies.
> I read the article but it doesn't really answer my question on whether
> it is worth going from 3Gig to 4gig... will SQL server be able to use
> that extra gig placed in the machine or will the OS take hold of the
> 1gig?
> Sounds like using AWE will take all the memory (besides 128 meg) unless
> a max memory setting is specified in SQL.. so in theory this could
> force it to use say 3.5gig of memory.
> But the article also suggests not using AWE for a 4gig machine.. so bit
> confused now :)
> I assume there would be advantages going from 3 to 4gig... anyone have
> any experiences in this?
>|||You have no need to use AWE, there are many disadvantages to using AWE as
well.
To determine if the 3GB switch will allow SQL Server to use more memory can
you tell us what the LEAST amount of free memory you see on the system?
What is that MAX amount of memory you see the SQL Server process consume?
On a side note you might not need to add the additional RAM is your buffer
cache hit ratio is already at 99%+
Paul
<davconts@.gmail.com> wrote in message
news:1155086938.963563.37190@.m79g2000cwm.googlegroups.com...
> Thanks for the replies.
> I read the article but it doesn't really answer my question on whether
> it is worth going from 3Gig to 4gig... will SQL server be able to use
> that extra gig placed in the machine or will the OS take hold of the
> 1gig?
> Sounds like using AWE will take all the memory (besides 128 meg) unless
> a max memory setting is specified in SQL.. so in theory this could
> force it to use say 3.5gig of memory.
> But the article also suggests not using AWE for a 4gig machine.. so bit
> confused now :)
> I assume there would be advantages going from 3 to 4gig... anyone have
> any experiences in this?
>|||Well we are actually doing a benchmark session tomorrow.
First we are going to run with 3gig of ram, and benchmark our app/db
performance.
Then, we will restart the SQL server with an additional gig of ram (now
4 gig) and compare.
FYI It's a 20gig database. CPU for the server looks adequate from what
I can see (dual xeon). The SQL server only runs SQL 2005, and it is
exclusive to our app.
>From a benchmark we did a month or so ago, I thought the memory usage
seemed ok.
The disks seemed to be a possible bottle neck - and there seemed to be
a fair bit of paging although how much is normal paging I'm not 100%
sure.
I'm hoping that the extra ram might help reduce disk usage/paging.
Oh I should also mention that we are runing raid 10, have the mdf on
d:, ldf file on e: and tempdb on c:\
David
Paul Widner wrote:
> You have no need to use AWE, there are many disadvantages to using AWE as
> well.
> To determine if the 3GB switch will allow SQL Server to use more memory can
> you tell us what the LEAST amount of free memory you see on the system?
> What is that MAX amount of memory you see the SQL Server process consume?
> On a side note you might not need to add the additional RAM is your buffer
> cache hit ratio is already at 99%+
> Paul
> <davconts@.gmail.com> wrote in message
> news:1155086938.963563.37190@.m79g2000cwm.googlegroups.com...
> > Thanks for the replies.
> >
> > I read the article but it doesn't really answer my question on whether
> > it is worth going from 3Gig to 4gig... will SQL server be able to use
> > that extra gig placed in the machine or will the OS take hold of the
> > 1gig?
> >
> > Sounds like using AWE will take all the memory (besides 128 meg) unless
> > a max memory setting is specified in SQL.. so in theory this could
> > force it to use say 3.5gig of memory.
> > But the article also suggests not using AWE for a 4gig machine.. so bit
> > confused now :)
> >
> > I assume there would be advantages going from 3 to 4gig... anyone have
> > any experiences in this?
> >|||I think that you will find no change or perhaps even a decreased performance
for AWE.
/AWE sets aside 1 GB for the OS AND AWE memory management extensions, and
adds a lot of processing overhead.
With /3GB, the OS still gets 1 GB, but you don't have the AWE overhead.
AWE Net change: Memory about the same, available CPU cycles reduced.
Depending upon the database, number of users, etc., I usually try to have
enough memory so that the majority of active tables are at all times in
cache. Main thing to watch for is memory page I/O. A lot of activity
indicates a need for more memory.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<davconts@.gmail.com> wrote in message
news:1155170138.095989.131980@.m73g2000cwd.googlegroups.com...
> Well we are actually doing a benchmark session tomorrow.
> First we are going to run with 3gig of ram, and benchmark our app/db
> performance.
> Then, we will restart the SQL server with an additional gig of ram (now
> 4 gig) and compare.
> FYI It's a 20gig database. CPU for the server looks adequate from what
> I can see (dual xeon). The SQL server only runs SQL 2005, and it is
> exclusive to our app.
>>From a benchmark we did a month or so ago, I thought the memory usage
> seemed ok.
> The disks seemed to be a possible bottle neck - and there seemed to be
> a fair bit of paging although how much is normal paging I'm not 100%
> sure.
> I'm hoping that the extra ram might help reduce disk usage/paging.
> Oh I should also mention that we are runing raid 10, have the mdf on
> d:, ldf file on e: and tempdb on c:\
> David
>
> Paul Widner wrote:
>> You have no need to use AWE, there are many disadvantages to using AWE as
>> well.
>> To determine if the 3GB switch will allow SQL Server to use more memory
>> can
>> you tell us what the LEAST amount of free memory you see on the system?
>> What is that MAX amount of memory you see the SQL Server process consume?
>> On a side note you might not need to add the additional RAM is your
>> buffer
>> cache hit ratio is already at 99%+
>> Paul
>> <davconts@.gmail.com> wrote in message
>> news:1155086938.963563.37190@.m79g2000cwm.googlegroups.com...
>> > Thanks for the replies.
>> >
>> > I read the article but it doesn't really answer my question on whether
>> > it is worth going from 3Gig to 4gig... will SQL server be able to use
>> > that extra gig placed in the machine or will the OS take hold of the
>> > 1gig?
>> >
>> > Sounds like using AWE will take all the memory (besides 128 meg) unless
>> > a max memory setting is specified in SQL.. so in theory this could
>> > force it to use say 3.5gig of memory.
>> > But the article also suggests not using AWE for a 4gig machine.. so bit
>> > confused now :)
>> >
>> > I assume there would be advantages going from 3 to 4gig... anyone have
>> > any experiences in this?
>> >
>
Ok I have a client that currently have 3gig of memory in their SQL
Server (SQL2005).
They are using the /3gb switch in their boot.ini so in theory SQL
server should use greater than 2 gig.
Ok from my understanding, if they put in an extra 1 gig of ram to make
the server now have 4 gig, would this mean that SQL Server would use 3
gig, and the OS 1gig?
So are their any advantages from going from 3gig to 4gig? (would it
help paging for example)
Look forward to your comments
Thanks!Hi,
Read this article..
http://www.sql-server-performance.com/awe_memory.asp
Thanks
Hari
SQL Server MVP
<davconts@.gmail.com> wrote in message
news:1155079279.501553.287040@.i42g2000cwa.googlegroups.com...
> Hey all,
> Ok I have a client that currently have 3gig of memory in their SQL
> Server (SQL2005).
> They are using the /3gb switch in their boot.ini so in theory SQL
> server should use greater than 2 gig.
> Ok from my understanding, if they put in an extra 1 gig of ram to make
> the server now have 4 gig, would this mean that SQL Server would use 3
> gig, and the OS 1gig?
> So are their any advantages from going from 3gig to 4gig? (would it
> help paging for example)
> Look forward to your comments
> Thanks!
>|||That article is not exactly accurate or clear in places. For instance, it
states, "AWE memory technology is used only for the RAM that exceeds the base
4GB of RAM". That is not correct. You can enable AWE with less than 4GB of
RAM.
Linchi
"Hari Prasad" wrote:
> Hi,
> Read this article..
> http://www.sql-server-performance.com/awe_memory.asp
> Thanks
> Hari
> SQL Server MVP
> <davconts@.gmail.com> wrote in message
> news:1155079279.501553.287040@.i42g2000cwa.googlegroups.com...
> > Hey all,
> >
> > Ok I have a client that currently have 3gig of memory in their SQL
> > Server (SQL2005).
> >
> > They are using the /3gb switch in their boot.ini so in theory SQL
> > server should use greater than 2 gig.
> >
> > Ok from my understanding, if they put in an extra 1 gig of ram to make
> > the server now have 4 gig, would this mean that SQL Server would use 3
> > gig, and the OS 1gig?
> >
> > So are their any advantages from going from 3gig to 4gig? (would it
> > help paging for example)
> >
> > Look forward to your comments
> >
> > Thanks!
> >
>
>|||Thanks for the replies.
I read the article but it doesn't really answer my question on whether
it is worth going from 3Gig to 4gig... will SQL server be able to use
that extra gig placed in the machine or will the OS take hold of the
1gig?
Sounds like using AWE will take all the memory (besides 128 meg) unless
a max memory setting is specified in SQL.. so in theory this could
force it to use say 3.5gig of memory.
But the article also suggests not using AWE for a 4gig machine.. so bit
confused now :)
I assume there would be advantages going from 3 to 4gig... anyone have
any experiences in this?|||Using AWE on a 4GB box just doesn't make much sense.
PAE (/3GB) will use 3 GB for SQL Server, so in a 4 GB box, AWE uses a fair
amount of resources (including memory) to manage the extended memory,
thereby negating most of the expected performance gain.
My experience is that you have to approach 5 GB + before AWE really shows
any gains.
Of course, it could be hardware related and YMMV.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<davconts@.gmail.com> wrote in message
news:1155086938.963563.37190@.m79g2000cwm.googlegroups.com...
> Thanks for the replies.
> I read the article but it doesn't really answer my question on whether
> it is worth going from 3Gig to 4gig... will SQL server be able to use
> that extra gig placed in the machine or will the OS take hold of the
> 1gig?
> Sounds like using AWE will take all the memory (besides 128 meg) unless
> a max memory setting is specified in SQL.. so in theory this could
> force it to use say 3.5gig of memory.
> But the article also suggests not using AWE for a 4gig machine.. so bit
> confused now :)
> I assume there would be advantages going from 3 to 4gig... anyone have
> any experiences in this?
>|||You have no need to use AWE, there are many disadvantages to using AWE as
well.
To determine if the 3GB switch will allow SQL Server to use more memory can
you tell us what the LEAST amount of free memory you see on the system?
What is that MAX amount of memory you see the SQL Server process consume?
On a side note you might not need to add the additional RAM is your buffer
cache hit ratio is already at 99%+
Paul
<davconts@.gmail.com> wrote in message
news:1155086938.963563.37190@.m79g2000cwm.googlegroups.com...
> Thanks for the replies.
> I read the article but it doesn't really answer my question on whether
> it is worth going from 3Gig to 4gig... will SQL server be able to use
> that extra gig placed in the machine or will the OS take hold of the
> 1gig?
> Sounds like using AWE will take all the memory (besides 128 meg) unless
> a max memory setting is specified in SQL.. so in theory this could
> force it to use say 3.5gig of memory.
> But the article also suggests not using AWE for a 4gig machine.. so bit
> confused now :)
> I assume there would be advantages going from 3 to 4gig... anyone have
> any experiences in this?
>|||Well we are actually doing a benchmark session tomorrow.
First we are going to run with 3gig of ram, and benchmark our app/db
performance.
Then, we will restart the SQL server with an additional gig of ram (now
4 gig) and compare.
FYI It's a 20gig database. CPU for the server looks adequate from what
I can see (dual xeon). The SQL server only runs SQL 2005, and it is
exclusive to our app.
>From a benchmark we did a month or so ago, I thought the memory usage
seemed ok.
The disks seemed to be a possible bottle neck - and there seemed to be
a fair bit of paging although how much is normal paging I'm not 100%
sure.
I'm hoping that the extra ram might help reduce disk usage/paging.
Oh I should also mention that we are runing raid 10, have the mdf on
d:, ldf file on e: and tempdb on c:\
David
Paul Widner wrote:
> You have no need to use AWE, there are many disadvantages to using AWE as
> well.
> To determine if the 3GB switch will allow SQL Server to use more memory can
> you tell us what the LEAST amount of free memory you see on the system?
> What is that MAX amount of memory you see the SQL Server process consume?
> On a side note you might not need to add the additional RAM is your buffer
> cache hit ratio is already at 99%+
> Paul
> <davconts@.gmail.com> wrote in message
> news:1155086938.963563.37190@.m79g2000cwm.googlegroups.com...
> > Thanks for the replies.
> >
> > I read the article but it doesn't really answer my question on whether
> > it is worth going from 3Gig to 4gig... will SQL server be able to use
> > that extra gig placed in the machine or will the OS take hold of the
> > 1gig?
> >
> > Sounds like using AWE will take all the memory (besides 128 meg) unless
> > a max memory setting is specified in SQL.. so in theory this could
> > force it to use say 3.5gig of memory.
> > But the article also suggests not using AWE for a 4gig machine.. so bit
> > confused now :)
> >
> > I assume there would be advantages going from 3 to 4gig... anyone have
> > any experiences in this?
> >|||I think that you will find no change or perhaps even a decreased performance
for AWE.
/AWE sets aside 1 GB for the OS AND AWE memory management extensions, and
adds a lot of processing overhead.
With /3GB, the OS still gets 1 GB, but you don't have the AWE overhead.
AWE Net change: Memory about the same, available CPU cycles reduced.
Depending upon the database, number of users, etc., I usually try to have
enough memory so that the majority of active tables are at all times in
cache. Main thing to watch for is memory page I/O. A lot of activity
indicates a need for more memory.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<davconts@.gmail.com> wrote in message
news:1155170138.095989.131980@.m73g2000cwd.googlegroups.com...
> Well we are actually doing a benchmark session tomorrow.
> First we are going to run with 3gig of ram, and benchmark our app/db
> performance.
> Then, we will restart the SQL server with an additional gig of ram (now
> 4 gig) and compare.
> FYI It's a 20gig database. CPU for the server looks adequate from what
> I can see (dual xeon). The SQL server only runs SQL 2005, and it is
> exclusive to our app.
>>From a benchmark we did a month or so ago, I thought the memory usage
> seemed ok.
> The disks seemed to be a possible bottle neck - and there seemed to be
> a fair bit of paging although how much is normal paging I'm not 100%
> sure.
> I'm hoping that the extra ram might help reduce disk usage/paging.
> Oh I should also mention that we are runing raid 10, have the mdf on
> d:, ldf file on e: and tempdb on c:\
> David
>
> Paul Widner wrote:
>> You have no need to use AWE, there are many disadvantages to using AWE as
>> well.
>> To determine if the 3GB switch will allow SQL Server to use more memory
>> can
>> you tell us what the LEAST amount of free memory you see on the system?
>> What is that MAX amount of memory you see the SQL Server process consume?
>> On a side note you might not need to add the additional RAM is your
>> buffer
>> cache hit ratio is already at 99%+
>> Paul
>> <davconts@.gmail.com> wrote in message
>> news:1155086938.963563.37190@.m79g2000cwm.googlegroups.com...
>> > Thanks for the replies.
>> >
>> > I read the article but it doesn't really answer my question on whether
>> > it is worth going from 3Gig to 4gig... will SQL server be able to use
>> > that extra gig placed in the machine or will the OS take hold of the
>> > 1gig?
>> >
>> > Sounds like using AWE will take all the memory (besides 128 meg) unless
>> > a max memory setting is specified in SQL.. so in theory this could
>> > force it to use say 3.5gig of memory.
>> > But the article also suggests not using AWE for a 4gig machine.. so bit
>> > confused now :)
>> >
>> > I assume there would be advantages going from 3 to 4gig... anyone have
>> > any experiences in this?
>> >
>
Subscribe to:
Posts (Atom)