How do i add Pubs database to Sql server 2005

Hi there,
I just want to play with Pubs data base that is available in
Management Studio and apply all the enhancements of T-SQL in SQL '05.
How would i install the PUBs and Northwind databases to the Management
Studio databases?
Thanks
-DDownload and install from MS:
http://www.microsoft.com/downloads/...&DisplayLang=en
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Learner" <pradev@.gmail.com> wrote in message
news:1139932399.753049.165860@.g47g2000cwa.googlegroups.com...
> Hi there,
> I just want to play with Pubs data base that is available in
> Management Studio and apply all the enhancements of T-SQL in SQL '05.
> How would i install the PUBs and Northwind databases to the Management
> Studio databases?
> Thanks
> -D
>|||Hi Tibor,
Yes i got the SQL2000SampleDb.msi already on to my desktop. But i
couldn't find an option to select so that i could install in Sql server
2005 rather than in Sql server 2000.
I also tried backing up the pubs data base from Sql server 2000 and
restroing it in Sql server 2005. It has thrown some error.
Do i need to set up some thing in order to forcebly install in Sql
server 2005 during the installation process of Sql2000SampleDb.msi?
Thanks
-L|||> I also tried backing up the pubs data base from Sql server 2000 and
> restroing it in Sql server 2005. It has thrown some error.
Above work, I've done that several times. But you need to provide us with mo
re information. What
errors? Did you use the MOVE option for the RESTORE command?

> Yes i got the SQL2000SampleDb.msi already on to my desktop. But i
> couldn't find an option to select so that i could install in Sql server
> 2005 rather than in Sql server 2000.
Same procedure. Just follow the readme, and adapt the steps for 2005 (like u
sing SSMS instead of
EM),
Whatever method you chose, remember that the databases will be in 80 compati
bility mode. Change
using sp_dbcmptlevel.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Learner" <pradev@.gmail.com> wrote in message
news:1139933503.450724.203960@.f14g2000cwb.googlegroups.com...
> Hi Tibor,
> Yes i got the SQL2000SampleDb.msi already on to my desktop. But i
> couldn't find an option to select so that i could install in Sql server
> 2005 rather than in Sql server 2000.
> I also tried backing up the pubs data base from Sql server 2000 and
> restroing it in Sql server 2005. It has thrown some error.
> Do i need to set up some thing in order to forcebly install in Sql
> server 2005 during the installation process of Sql2000SampleDb.msi?
> Thanks
> -L
>|||Tibor,
The mssage i got in the final step of restoration process when i
clicked on OK after the adding the pub.bak from
-Microsoft Sql Server
+80
+90
-MS Sql
- BACKUP
-pubs.bak
from Locate Backup file wizard.
The error i got was
TITLE: Microsoft SQL Server Management Studio
--
Restore failed for Server 'DEVI\SQLDM2005'. (Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The operating system returned the error
'32(The process cannot access the file because it is being used by
another process.)' while attempting
'RestoreContainer::ValidateTargetForCrea
tion' on 'C:\Program
Files\Microsoft SQL Server\MSSQL\data\pubs.mdf'.
(Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?Prod...>
LinkId=20476
BUTTONS:
OK
--
I am not sure why it is complaining about 'its being used by another
process' I don't have it available under my server explorer.
I can send the word doc of all the snap shots that i documented during
the restoration process if you think that helps.
Thanks
-L|||How many instances of SQL Server are you running? It sounds like the MDF
you are trying to attach is already attached to another instance of SQL
Server...
"Learner" <pradev@.gmail.com> wrote in message
news:1139935089.008898.70290@.o13g2000cwo.googlegroups.com...
> Tibor,
> The mssage i got in the final step of restoration process when i
> clicked on OK after the adding the pub.bak from
> -Microsoft Sql Server
> +80
> +90
> -MS Sql
> - BACKUP
> -pubs.bak
> from Locate Backup file wizard.
> The error i got was
> TITLE: Microsoft SQL Server Management Studio
> --
> Restore failed for Server 'DEVI\SQLDM2005'. (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> System.Data.SqlClient.SqlError: The operating system returned the error
> '32(The process cannot access the file because it is being used by
> another process.)' while attempting
> 'RestoreContainer::ValidateTargetForCrea
tion' on 'C:\Program
> Files\Microsoft SQL Server\MSSQL\data\pubs.mdf'.
> (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...
0&LinkId=20476
> --
> BUTTONS:
> OK
> --
> I am not sure why it is complaining about 'its being used by another
> process' I don't have it available under my server explorer.
> I can send the word doc of all the snap shots that i documented during
> the restoration process if you think that helps.
> Thanks
> -L
>|||Hello,
I have three servers registered in my Registered Servers window.
Devi (Sql server 2000)
Devi\Sqldm2005(Sql server 2005)
Devserver\Sql2005(Sql server 2005)
And i have only instance running under my Object Explorer
Devi\Sqldm2005(Sql server 2005)
I have pubs and Northwind databases by default under the server
Devi(which is sql server 2000).
But i don't have it attached it to my Object Explorer if at all that
makes any difference.
I am not sure if i am answering your question right though.
Tahanks
-D|||Look in Books Online for the syntax of sp_attach_db. You need to provide the
physical file names for
both the mdf and the ldf file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Learner" <pradev@.gmail.com> wrote in message
news:1139936762.694587.151210@.g47g2000cwa.googlegroups.com...
> Hello,
> I have three servers registered in my Registered Servers window.
> Devi (Sql server 2000)
> Devi\Sqldm2005(Sql server 2005)
> Devserver\Sql2005(Sql server 2005)
> And i have only instance running under my Object Explorer
> Devi\Sqldm2005(Sql server 2005)
> I have pubs and Northwind databases by default under the server
> Devi(which is sql server 2000).
> But i don't have it attached it to my Object Explorer if at all that
> makes any difference.
> I am not sure if i am answering your question right though.
>
> Tahanks
> -D
>|||Tibor,
You mean i need to do it in Management Studio rather than using the
GUI wizards? I will try doing it through Management Studio.
But mean while if you are comfortable with, i just sent over word
document that i have made during the restoring process to your hotmail
account. Could you please suggest me if i did it right?
Thanks
-L|||Yes, I'm referring to write and execute the TSQL commands in stead of using
the GUI dialogs. I never
use the GUI for these things, so I can't be much help there, I'm afraid...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Learner" <pradev@.gmail.com> wrote in message
news:1139937684.832280.213070@.g47g2000cwa.googlegroups.com...
> Tibor,
> You mean i need to do it in Management Studio rather than using the
> GUI wizards? I will try doing it through Management Studio.
> But mean while if you are comfortable with, i just sent over word
> document that i have made during the restoring process to your hotmail
> account. Could you please suggest me if i did it right?
> Thanks
> -L
>sql

How do a get a listing of all available SQL Servers on a network.

I want to create a web app that will allow a user to select from a drop down or lookup all available SQL Server databases.

Thanks in advance,
Jeremyi answered my own question... hope this helps some one

To restate my problem.
I need an app that will list all of the available SQL Servers on a network. There are many ways to do this ... this is one. I would like to see better ways if anyone has time.

1. Download the SQLUtils.dll from (watch for line wrap)
http://codeproject.com/useritems/listsqlservers.asp?print=true

2. Register the SQLUtils.dll using regsvr32.exe
> regsvr32 c:/inetpub/wwwroot/lib/sqlutils.dll

3. Build your web form

// C#

using SQLUtils;

protected System.Web.UI.WebControls.TextBox TextBox1;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.ListBox ListBox1;

private void Button1_Click(object sender, System.EventArgs e)
{
SQLUtils.ListServers oSqlUtils = new SQLUtils.ListServers();
// String svr = new String();
oSqlUtils.Domain = TextBox1.Text;
oSqlUtils.GetSQLServers();
foreach( String svr in oSqlUtils.Servers )
{
ListBox1.Items.Add(svr);
} // end of foreach loop
} // end of Button1_Click()

4. You will need to add a reference in your project to the .dll file. Right click on the project and select "Add Reference". Browse to the location and select.

I also found these... (watch for line wrap)
http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=14327

How can you prevent the data changes message during editing a

Hi David,
I think you are right that this is not a server's job. I assumed that the
server has the original record available in the Deleted version of the recor
d
in a trigger - but this is probably not the record state the user first read
into a form.
My problem is that I have a big application (a mail-order processing system)
written in Access 2000 FE (.mdb) file with lots of forms with bound ODBC
server tables/queries. I have 850 queries and a lot of code. Up to now I use
d
pessimistic locking but this is not possible anymore (I think) because if I
link via ODBC to SQL server I do not have the option to lock pessimisticly
anymore.
In principle I could use the optimistic locking but how can I deal with data
changes in a record made by other users/jobs. If I cannot lock, a job or
program could "get caught out" as well and how would the program then know
what to do (from the choices: copy the data to the clipboard, overwrite or
loose it). I really think Microsoft should solve this problem by changing th
e
bound forms so that only the changed fields get updated and overwrite by
default - may with an option to switch this behaviour on and off...
It should never get to that stage, it must be prevented via short time locks
that a record gets changed during a read and update transaction.
It is okay to assume that if a user field change clashes with another user
field change the last writing user "wins" provided only the changed fields
will be updated.
If I could I would like to leave everything in ODBC or DAO and convert
slowly to stored procedures and use ADO, ... otherwise it would be a mega jo
b
to convert all in one go. I might have to do this if there is no way around
the locking problem.
Do you or anybody else know a way around it - it would be like light in the
dark tunnel for me!
Thanks.
Oliver
"David Gugick" wrote:

> Oliver wrote:
> I don't agree with your assessment. This is an application programming
> issue and not one for the database to manage on its own. You're
> suggesting that the server update a row that has been updated in the
> interim by another process just because the columns being updated are
> not the same. I would argue that there's no way for SQL Server to know
> if changing a single column value in a row would somehow affect business
> rules and know whether or not the proposed row changes are valid.
> Many applications can deal with this scenario by assuming the last
> update should be the most current. In that scenario, there is no
> additional programming required. If you need to manage concurrency and
> changes to a row by another session to avoid overwriting those changes,
> you should use a timestamp. You pass the timestamp value with the other
> column values to your stored procedure and the procedure does the work.
> The application should be able to handle the condition where the row was
> not updated because an error was raised and then requery the data and
> inform the end-user. All your DML should be done in stored procedures.
> In the case where there is no end-user, your application code should log
> an error condition that can be managed manually in an interactive
> fashion or it could requery the data, assuming this is something it can
> work around.
> For a nightly batch process, you could lock the entire table within your
> transaction.
>
> I'm not sure what you are describing here. A change is a change.
> Presumably, you have a stored procedure to manage each type of change to
> your data. Maybe you can elaborate on this part a little more.
>
> --
> David Gugick - SQL Server MVP
> Quest Software
>Oliver wrote:
> Hi David,
> I think you are right that this is not a server's job. I assumed that
> the server has the original record available in the Deleted version
> of the record in a trigger - but this is probably not the record
> state the user first read into a form.
> Oliver
Can't you use either the dbOptimistic or dbOptimisticValue LockEdit
parameter on the Recordset? I think dbOptimisticValue does a column by
column value comparison before updating. It's been a long time since
I've looked at DAO, so this might be a better question for an Access
newsgroup.

> I really think Microsoft
> should solve this problem by changing the bound forms so that only
> the changed fields get updated and overwrite by default - may with an
> option to switch this behaviour on and off...
I think this is a bit of a risk for those users programming using bound
forms (not recommended in my opinion for any important application - but
that's another topic). The point I tried to make in my last post was
that it's too much of a risk to update some columns and not others -
there's no way to know if the relationship between them is important in
some manner.
David Gugick - SQL Server MVP
Quest Software

How can I use full memory in x64 OS with 32bit SQL

I have the following:
Windows Server 2003 Enterprise x64
SQL Server Enterprise x32
In order for SQL to use all 16 GB of ram available are there in special
settings such as /pae, /awe, or /3GB that I need to use?
When using certain monitor tools it shows my memory usage at 100 percent
when that doesn't seem right.
Hope that is enough info.
On 64-bit platforms, you don't use the /PAE /3GB switches. You do have to
use sp_configure:
sp_configure 'awe enabled', 1
go
reconfigure with override
go
sp_configure 'max server memory (MB)', 14336
go
reconfigure with override
go
Stop and start SQL Server. I chose the max memory of 14GB, since you should
leave 2GB for the OS.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"jason7655" <jason7655@.discussions.microsoft.com> wrote in message
news:619021D5-16A6-4FB4-AF44-E1E0DB1209B2@.microsoft.com...
I have the following:
Windows Server 2003 Enterprise x64
SQL Server Enterprise x32
In order for SQL to use all 16 GB of ram available are there in special
settings such as /pae, /awe, or /3GB that I need to use?
When using certain monitor tools it shows my memory usage at 100 percent
when that doesn't seem right.
Hope that is enough info.
|||"Tom Moreau" wrote:

> On 64-bit platforms, you don't use the /PAE /3GB switches. You do have to
> use sp_configure:
> sp_configure 'awe enabled', 1
> go
> reconfigure with override
> go
> sp_configure 'max server memory (MB)', 14336
> go
> reconfigure with override
> go
> Stop and start SQL Server. I chose the max memory of 14GB, since you should
> leave 2GB for the OS.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "jason7655" <jason7655@.discussions.microsoft.com> wrote in message
> news:619021D5-16A6-4FB4-AF44-E1E0DB1209B2@.microsoft.com...
> I have the following:
> Windows Server 2003 Enterprise x64
> SQL Server Enterprise x32
> In order for SQL to use all 16 GB of ram available are there in special
> settings such as /pae, /awe, or /3GB that I need to use?
> When using certain monitor tools it shows my memory usage at 100 percent
> when that doesn't seem right.
> Hope that is enough info.
>
awe enable is set to :
run value: 0
Config Value:0
Minimum: 0
Maximum: 1
Currently my "mas server memory" is set to :
run value: 2147483647
Config Value:2147483647
Minimum: 4
Maximum:2147483647
Does your suggestion remain the same or would I just removed the max server
portion of that statement?
|||Just run my code and restart SQL Server.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"jason7655" <jason7655@.discussions.microsoft.com> wrote in message
news:8F14CDBE-1D38-4DBD-AE07-2B760EE0901A@.microsoft.com...
"Tom Moreau" wrote:

> On 64-bit platforms, you don't use the /PAE /3GB switches. You do have to
> use sp_configure:
> sp_configure 'awe enabled', 1
> go
> reconfigure with override
> go
> sp_configure 'max server memory (MB)', 14336
> go
> reconfigure with override
> go
> Stop and start SQL Server. I chose the max memory of 14GB, since you
> should
> leave 2GB for the OS.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "jason7655" <jason7655@.discussions.microsoft.com> wrote in message
> news:619021D5-16A6-4FB4-AF44-E1E0DB1209B2@.microsoft.com...
> I have the following:
> Windows Server 2003 Enterprise x64
> SQL Server Enterprise x32
> In order for SQL to use all 16 GB of ram available are there in special
> settings such as /pae, /awe, or /3GB that I need to use?
> When using certain monitor tools it shows my memory usage at 100 percent
> when that doesn't seem right.
> Hope that is enough info.
>
awe enable is set to :
run value: 0
Config Value:0
Minimum: 0
Maximum: 1
Currently my "mas server memory" is set to :
run value: 2147483647
Config Value:2147483647
Minimum: 4
Maximum:2147483647
Does your suggestion remain the same or would I just removed the max server
portion of that statement?

How can I use full memory in x64 OS with 32bit SQL

I have the following:
Windows Server 2003 Enterprise x64
SQL Server Enterprise x32
In order for SQL to use all 16 GB of ram available are there in special
settings such as /pae, /awe, or /3GB that I need to use?
When using certain monitor tools it shows my memory usage at 100 percent
when that doesn't seem right.
Hope that is enough info.On 64-bit platforms, you don't use the /PAE /3GB switches. You do have to
use sp_configure:
sp_configure 'awe enabled', 1
go
reconfigure with override
go
sp_configure 'max server memory (MB)', 14336
go
reconfigure with override
go
Stop and start SQL Server. I chose the max memory of 14GB, since you should
leave 2GB for the OS.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"jason7655" <jason7655@.discussions.microsoft.com> wrote in message
news:619021D5-16A6-4FB4-AF44-E1E0DB1209B2@.microsoft.com...
I have the following:
Windows Server 2003 Enterprise x64
SQL Server Enterprise x32
In order for SQL to use all 16 GB of ram available are there in special
settings such as /pae, /awe, or /3GB that I need to use?
When using certain monitor tools it shows my memory usage at 100 percent
when that doesn't seem right.
Hope that is enough info.|||"Tom Moreau" wrote:

> On 64-bit platforms, you don't use the /PAE /3GB switches. You do have to
> use sp_configure:
> sp_configure 'awe enabled', 1
> go
> reconfigure with override
> go
> sp_configure 'max server memory (MB)', 14336
> go
> reconfigure with override
> go
> Stop and start SQL Server. I chose the max memory of 14GB, since you shou
ld
> leave 2GB for the OS.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "jason7655" <jason7655@.discussions.microsoft.com> wrote in message
> news:619021D5-16A6-4FB4-AF44-E1E0DB1209B2@.microsoft.com...
> I have the following:
> Windows Server 2003 Enterprise x64
> SQL Server Enterprise x32
> In order for SQL to use all 16 GB of ram available are there in special
> settings such as /pae, /awe, or /3GB that I need to use?
> When using certain monitor tools it shows my memory usage at 100 percent
> when that doesn't seem right.
> Hope that is enough info.
>
awe enable is set to :
run value: 0
Config Value:0
Minimum: 0
Maximum: 1
Currently my "mas server memory" is set to :
run value: 2147483647
Config Value:2147483647
Minimum: 4
Maximum:2147483647
Does your suggestion remain the same or would I just removed the max server
portion of that statement?|||Just run my code and restart SQL Server.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"jason7655" <jason7655@.discussions.microsoft.com> wrote in message
news:8F14CDBE-1D38-4DBD-AE07-2B760EE0901A@.microsoft.com...
"Tom Moreau" wrote:

> On 64-bit platforms, you don't use the /PAE /3GB switches. You do have to
> use sp_configure:
> sp_configure 'awe enabled', 1
> go
> reconfigure with override
> go
> sp_configure 'max server memory (MB)', 14336
> go
> reconfigure with override
> go
> Stop and start SQL Server. I chose the max memory of 14GB, since you
> should
> leave 2GB for the OS.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "jason7655" <jason7655@.discussions.microsoft.com> wrote in message
> news:619021D5-16A6-4FB4-AF44-E1E0DB1209B2@.microsoft.com...
> I have the following:
> Windows Server 2003 Enterprise x64
> SQL Server Enterprise x32
> In order for SQL to use all 16 GB of ram available are there in special
> settings such as /pae, /awe, or /3GB that I need to use?
> When using certain monitor tools it shows my memory usage at 100 percent
> when that doesn't seem right.
> Hope that is enough info.
>
awe enable is set to :
run value: 0
Config Value:0
Minimum: 0
Maximum: 1
Currently my "mas server memory" is set to :
run value: 2147483647
Config Value:2147483647
Minimum: 4
Maximum:2147483647
Does your suggestion remain the same or would I just removed the max server
portion of that statement?

How can I use full memory in x64 OS with 32bit SQL

I have the following:
Windows Server 2003 Enterprise x64
SQL Server Enterprise x32
In order for SQL to use all 16 GB of ram available are there in special
settings such as /pae, /awe, or /3GB that I need to use?
When using certain monitor tools it shows my memory usage at 100 percent
when that doesn't seem right.
Hope that is enough info.On 64-bit platforms, you don't use the /PAE /3GB switches. You do have to
use sp_configure:
sp_configure 'awe enabled', 1
go
reconfigure with override
go
sp_configure 'max server memory (MB)', 14336
go
reconfigure with override
go
Stop and start SQL Server. I chose the max memory of 14GB, since you should
leave 2GB for the OS.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"jason7655" <jason7655@.discussions.microsoft.com> wrote in message
news:619021D5-16A6-4FB4-AF44-E1E0DB1209B2@.microsoft.com...
I have the following:
Windows Server 2003 Enterprise x64
SQL Server Enterprise x32
In order for SQL to use all 16 GB of ram available are there in special
settings such as /pae, /awe, or /3GB that I need to use?
When using certain monitor tools it shows my memory usage at 100 percent
when that doesn't seem right.
Hope that is enough info.|||"Tom Moreau" wrote:
> On 64-bit platforms, you don't use the /PAE /3GB switches. You do have to
> use sp_configure:
> sp_configure 'awe enabled', 1
> go
> reconfigure with override
> go
> sp_configure 'max server memory (MB)', 14336
> go
> reconfigure with override
> go
> Stop and start SQL Server. I chose the max memory of 14GB, since you should
> leave 2GB for the OS.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "jason7655" <jason7655@.discussions.microsoft.com> wrote in message
> news:619021D5-16A6-4FB4-AF44-E1E0DB1209B2@.microsoft.com...
> I have the following:
> Windows Server 2003 Enterprise x64
> SQL Server Enterprise x32
> In order for SQL to use all 16 GB of ram available are there in special
> settings such as /pae, /awe, or /3GB that I need to use?
> When using certain monitor tools it shows my memory usage at 100 percent
> when that doesn't seem right.
> Hope that is enough info.
>
awe enable is set to :
run value: 0
Config Value:0
Minimum: 0
Maximum: 1
Currently my "mas server memory" is set to :
run value: 2147483647
Config Value:2147483647
Minimum: 4
Maximum:2147483647
Does your suggestion remain the same or would I just removed the max server
portion of that statement?|||Just run my code and restart SQL Server.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"jason7655" <jason7655@.discussions.microsoft.com> wrote in message
news:8F14CDBE-1D38-4DBD-AE07-2B760EE0901A@.microsoft.com...
"Tom Moreau" wrote:
> On 64-bit platforms, you don't use the /PAE /3GB switches. You do have to
> use sp_configure:
> sp_configure 'awe enabled', 1
> go
> reconfigure with override
> go
> sp_configure 'max server memory (MB)', 14336
> go
> reconfigure with override
> go
> Stop and start SQL Server. I chose the max memory of 14GB, since you
> should
> leave 2GB for the OS.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "jason7655" <jason7655@.discussions.microsoft.com> wrote in message
> news:619021D5-16A6-4FB4-AF44-E1E0DB1209B2@.microsoft.com...
> I have the following:
> Windows Server 2003 Enterprise x64
> SQL Server Enterprise x32
> In order for SQL to use all 16 GB of ram available are there in special
> settings such as /pae, /awe, or /3GB that I need to use?
> When using certain monitor tools it shows my memory usage at 100 percent
> when that doesn't seem right.
> Hope that is enough info.
>
awe enable is set to :
run value: 0
Config Value:0
Minimum: 0
Maximum: 1
Currently my "mas server memory" is set to :
run value: 2147483647
Config Value:2147483647
Minimum: 4
Maximum:2147483647
Does your suggestion remain the same or would I just removed the max server
portion of that statement?

How can i test my SPs and Functions

Hi,
I want to Know How can i test my SPs and functions for load and
performance. Is there any third party Tools available for this .
Thanking you
Aneesh
could look at OStress as per below
http://support.microsoft.com/default...b;en-us;887057
I've also used SQLLS that used to be in the Back Office 4.5 / SQL 7 Resource
Kit to good effect
cheers,
Andy.
"AR" <aneesh.r@.eostek.com> wrote in message
news:eote$Oc3EHA.536@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I want to Know How can i test my SPs and functions for load and
> performance. Is there any third party Tools available for this .
> Thanking you
> Aneesh
>