More Memory

Is there any way to get Standard SQL Server 2000 to use more than 2GB of
memory? I am running on a 2003 standard server w/the 3GB switch in the
boot.ini, but SQL still appears to only use 2GB of memory in the task manager.
Thanks> Is there any way to get Standard SQL Server 2000 to use more than 2GB of
> memory?
No. You need to step up to Enterprise Edition to use more than 2GB. See
'Maximum Capacity Specifications' in the Books Online for details.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Matt L." <Matt L.@.discussions.microsoft.com> wrote in message
news:6795FFF1-A0DB-40CB-82C5-35D3473FFB42@.microsoft.com...
> Is there any way to get Standard SQL Server 2000 to use more than 2GB of
> memory? I am running on a 2003 standard server w/the 3GB switch in the
> boot.ini, but SQL still appears to only use 2GB of memory in the task
> manager.
> Thanks|||OK, Thanks Dan
"Dan Guzman" wrote:
> > Is there any way to get Standard SQL Server 2000 to use more than 2GB of
> > memory?
> No. You need to step up to Enterprise Edition to use more than 2GB. See
> 'Maximum Capacity Specifications' in the Books Online for details.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Matt L." <Matt L.@.discussions.microsoft.com> wrote in message
> news:6795FFF1-A0DB-40CB-82C5-35D3473FFB42@.microsoft.com...
> > Is there any way to get Standard SQL Server 2000 to use more than 2GB of
> > memory? I am running on a 2003 standard server w/the 3GB switch in the
> > boot.ini, but SQL still appears to only use 2GB of memory in the task
> > manager.
> >
> > Thanks
>
>

More Memory

Is there any way to get Standard SQL Server 2000 to use more than 2GB of
memory? I am running on a 2003 standard server w/the 3GB switch in the
boot.ini, but SQL still appears to only use 2GB of memory in the task manage
r.
Thanks> Is there any way to get Standard SQL Server 2000 to use more than 2GB of
> memory?
No. You need to step up to Enterprise Edition to use more than 2GB. See
'Maximum Capacity Specifications' in the Books Online for details.
Hope this helps.
Dan Guzman
SQL Server MVP
"Matt L." <Matt L.@.discussions.microsoft.com> wrote in message
news:6795FFF1-A0DB-40CB-82C5-35D3473FFB42@.microsoft.com...
> Is there any way to get Standard SQL Server 2000 to use more than 2GB of
> memory? I am running on a 2003 standard server w/the 3GB switch in the
> boot.ini, but SQL still appears to only use 2GB of memory in the task
> manager.
> Thanks|||OK, Thanks Dan
"Dan Guzman" wrote:

> No. You need to step up to Enterprise Edition to use more than 2GB. See
> 'Maximum Capacity Specifications' in the Books Online for details.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Matt L." <Matt L.@.discussions.microsoft.com> wrote in message
> news:6795FFF1-A0DB-40CB-82C5-35D3473FFB42@.microsoft.com...
>
>

Monitoring SQL SERVER

Hi,
Anyone know a graphical tool very good to monitor all
process in the SQL - LOCKS - MEMORY, PROCESSOR All this
kind of thing !
THANK'S
Roberto CarrascoPerfmon and SQL Enterprise manager?
Kevin Connell, MCDBA
----
The views expressed here are my own
and not of my employer.
----
"Roberto Carrasco" <roberto_carrasco@.msn.com> wrote in message
news:0fad01c378b1$7cb00200$a501280a@.phx.gbl...
> Hi,
> Anyone know a graphical tool very good to monitor all
> process in the SQL - LOCKS - MEMORY, PROCESSOR All this
> kind of thing !
> THANK'S
> Roberto Carrasco
>|||You could post the results from sp_who or sp_who2 to a
web page...
Also, this product looks pretty good, but I'm sure it
costs...
http://quest.com/solutions/sql_server.asp
Sincerely,
Invotion Engineering Team
Advanced Microsoft Hosting Solutions
http://www.Invotion.com
>--Original Message--
>Hi,
>Anyone know a graphical tool very good to monitor all
>process in the SQL - LOCKS - MEMORY, PROCESSOR All this
>kind of thing !
>THANK'S
>Roberto Carrasco
>.
>|||You could monitor SQl Servers with some 3rd party
products I'm using Server Monitor Professional
(http://www.purenetworking.net/Products/ServerMonitor/Serve
rMonitorPro.htm) You could download a evel copy for free -
it runs on my local machine and connects to the SQL server
perf monitor - you could set up e-mails and paging for
every counter.
MJ
>--Original Message--
>Hi,
>Anyone know a graphical tool very good to monitor all
>process in the SQL - LOCKS - MEMORY, PROCESSOR All this
>kind of thing !
>THANK'S
>Roberto Carrasco
>.
>|||Quest Software has some great tools. www.quest.com.
--
Denny Cherry
DBA
GameSpy Industries
"Roberto Carrasco" <roberto_carrasco@.msn.com> wrote in message
news:0fad01c378b1$7cb00200$a501280a@.phx.gbl...
> Hi,
> Anyone know a graphical tool very good to monitor all
> process in the SQL - LOCKS - MEMORY, PROCESSOR All this
> kind of thing !
> THANK'S
> Roberto Carrasco
>|||Spotlight for SQL Server:
http://www.quest.com/spotlight_sql/
You can also check a tool I designed to get some
information as well. Uses IIS and is written in ASP.
http://www.edgardovaldez.us/sqlmonitor/
Let me know if you have any questions.
Edgardo Valdez
MCSD, MCDBA, MCSE, MCP+I
http://www.edgardovaldez.us/
>--Original Message--
>Hi,
>Anyone know a graphical tool very good to monitor all
>process in the SQL - LOCKS - MEMORY, PROCESSOR All this
>kind of thing !
>THANK'S
>Roberto Carrasco
>.
>|||Roberto,
Try Application Spotlight from Quest Software. You can
download a trial from their site.
David S. Hale
O/S Technical Support Manager
Unisys
>--Original Message--
>Perfmon and SQL Enterprise manager?
>
>--
>Kevin Connell, MCDBA
>----
>The views expressed here are my own
>and not of my employer.
>----
>"Roberto Carrasco" <roberto_carrasco@.msn.com> wrote in
message
>news:0fad01c378b1$7cb00200$a501280a@.phx.gbl...
>> Hi,
>> Anyone know a graphical tool very good to monitor all
>> process in the SQL - LOCKS - MEMORY, PROCESSOR All this
>> kind of thing !
>> THANK'S
>> Roberto Carrasco
>
>.
>

Monitoring Server Memory.

Hi, we need to monitor the memory used for sql server. The person who
want to use de counters has administrative privileges on the server but
not in sql server, so he couldnt use the sql server counters in
Performance Monitor Tool.
I am member of the sysadmin server role in sql server and I can use the
counters, So, Do somebody know if the user can have some privileges
differente to sysadmin on sql server to use the counters?
Thanks a lot for your help!
*** Sent via Developersdex http://www.codecomments.com ***
Hi,
User with Admin rights on the Server (operating system) should be able to
see all the counters.
FYI, OS Administrators by default will the member of BUILD\ADMIN user in sql
server. BUILD\ADMIN is the part of sysadmin role
Thanks
Hari
SQL Server MVP
"MariaGuzman" <marisa@.devdex.com> wrote in message
news:Oj6VaHHQFHA.4020@.tk2msftngp13.phx.gbl...
> Hi, we need to monitor the memory used for sql server. The person who
> want to use de counters has administrative privileges on the server but
> not in sql server, so he couldnt use the sql server counters in
> Performance Monitor Tool.
> I am member of the sysadmin server role in sql server and I can use the
> counters, So, Do somebody know if the user can have some privileges
> differente to sysadmin on sql server to use the counters?
> Thanks a lot for your help!
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
|||Thanks for your answere. I forgot to tell you that the
builtin\administrator is not a member of the sysadmin role on this
server.
*** Sent via Developersdex http://www.codecomments.com ***

Monitoring Server Memory.

Hi, we need to monitor the memory used for sql server. The person who
want to use de counters has administrative privileges on the server but
not in sql server, so he couldnt use the sql server counters in
Performance Monitor Tool.
I am member of the sysadmin server role in sql server and I can use the
counters, So, Do somebody know if the user can have some privileges
differente to sysadmin on sql server to use the counters'
Thanks a lot for your help!
*** Sent via Developersdex http://www.codecomments.com ***Hi,
User with Admin rights on the Server (operating system) should be able to
see all the counters.
FYI, OS Administrators by default will the member of BUILD\ADMIN user in sql
server. BUILD\ADMIN is the part of sysadmin role
Thanks
Hari
SQL Server MVP
"MariaGuzman" <marisa@.devdex.com> wrote in message
news:Oj6VaHHQFHA.4020@.tk2msftngp13.phx.gbl...
> Hi, we need to monitor the memory used for sql server. The person who
> want to use de counters has administrative privileges on the server but
> not in sql server, so he couldnt use the sql server counters in
> Performance Monitor Tool.
> I am member of the sysadmin server role in sql server and I can use the
> counters, So, Do somebody know if the user can have some privileges
> differente to sysadmin on sql server to use the counters'
> Thanks a lot for your help!
>
>
> *** Sent via Developersdex http://www.codecomments.com ***|||Thanks for your answere. I forgot to tell you that the
builtin\administrator is not a member of the sysadmin role on this
server.
*** Sent via Developersdex http://www.codecomments.com ***

Monitoring Server Memory.

Hi, we need to monitor the memory used for sql server. The person who
want to use de counters has administrative privileges on the server but
not in sql server, so he couldn´t use the sql server counters in
Performance Monitor Tool.
I am member of the sysadmin server role in sql server and I can use the
counters, So, Do somebody know if the user can have some privileges
differente to sysadmin on sql server to use the counters'
Thanks a lot for your help!
*** Sent via Developersdex http://www.developersdex.com ***Hi,
User with Admin rights on the Server (operating system) should be able to
see all the counters.
FYI, OS Administrators by default will the member of BUILD\ADMIN user in sql
server. BUILD\ADMIN is the part of sysadmin role
Thanks
Hari
SQL Server MVP
"MariaGuzman" <marisa@.devdex.com> wrote in message
news:Oj6VaHHQFHA.4020@.tk2msftngp13.phx.gbl...
> Hi, we need to monitor the memory used for sql server. The person who
> want to use de counters has administrative privileges on the server but
> not in sql server, so he couldn´t use the sql server counters in
> Performance Monitor Tool.
> I am member of the sysadmin server role in sql server and I can use the
> counters, So, Do somebody know if the user can have some privileges
> differente to sysadmin on sql server to use the counters'
> Thanks a lot for your help!
>
>
> *** Sent via Developersdex http://www.developersdex.com ***

Monitoring Query Performance

Is there any table in SQL Server 2000 which lists the queries currently
cached in memory and statistics on those queries e.g. execution time, number
of executions cost, etc. I would like to be able to determine the queries
that have the highest cost to target for performance tuning first.
Not really. You have some information in master..syscacheobjects, but that are only the cached plans
(those that are cached in the first place, of course). You can have a profiler trace running to pick
up the measures you are interested in and to your tuning based on that profiler trace.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:C5531A9C-7344-4734-B041-7A83FA31F5F8@.microsoft.com...
> Is there any table in SQL Server 2000 which lists the queries currently
> cached in memory and statistics on those queries e.g. execution time, number
> of executions cost, etc. I would like to be able to determine the queries
> that have the highest cost to target for performance tuning first.

Monitoring Query Performance

Is there any table in SQL Server 2000 which lists the queries currently
cached in memory and statistics on those queries e.g. execution time, number
of executions cost, etc. I would like to be able to determine the queries
that have the highest cost to target for performance tuning first.Not really. You have some information in master..syscacheobjects, but that are only the cached plans
(those that are cached in the first place, of course). You can have a profiler trace running to pick
up the measures you are interested in and to your tuning based on that profiler trace.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:C5531A9C-7344-4734-B041-7A83FA31F5F8@.microsoft.com...
> Is there any table in SQL Server 2000 which lists the queries currently
> cached in memory and statistics on those queries e.g. execution time, number
> of executions cost, etc. I would like to be able to determine the queries
> that have the highest cost to target for performance tuning first.

Monitoring Query Performance

Is there any table in SQL Server 2000 which lists the queries currently
cached in memory and statistics on those queries e.g. execution time, number
of executions cost, etc. I would like to be able to determine the queries
that have the highest cost to target for performance tuning first.Not really. You have some information in master..syscacheobjects, but that a
re only the cached plans
(those that are cached in the first place, of course). You can have a profil
er trace running to pick
up the measures you are interested in and to your tuning based on that profi
ler trace.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:C5531A9C-7344-4734-B041-7A83FA31F5F8@.microsoft.com...
> Is there any table in SQL Server 2000 which lists the queries currently
> cached in memory and statistics on those queries e.g. execution time, numb
er
> of executions cost, etc. I would like to be able to determine the queries
> that have the highest cost to target for performance tuning first.

monitoring memory usage of particular database

We would like to individually monitor the memory usage of all the different
databases on a server. In Current Activity in Enterprise Manager I see Memor
y Usage for the databases - is there a way to log that information? I didn't
see Memory Usage as a data
column in the Trace Properties in the Profiler. Thank you.Could the Perfmon be of any help? You ahve database counters there, depends
on what information you need.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

monitoring memory usage of particular database

We would like to individually monitor the memory usage of all the different databases on a server. In Current Activity in Enterprise Manager I see Memory Usage for the databases - is there a way to log that information? I didn't see Memory Usage as a data
column in the Trace Properties in the Profiler. Thank you.
Could the Perfmon be of any help? You ahve database counters there, depends
on what information you need.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

monitoring application performence

hi all
I'm running a sql 2000 standard edition server on win 2000 server.
one instance on a 3 gb memory, 2 cpus ,machine.
there are about 20 databases on the server; however I'm encounering a
problem with a spacific 500 mb db.
the problem is: 7 client stations located at a different city communicating
(only with)the problematic db on the server threw a single application via
iis. for the last few months the respons time is queit slow. tables are
reletivly small (the biggest is 60000 rows but the rest a only a few hunderd
each)
now... I'm trying yo isolate the problem.
my first question: is it true to say that since the rest of the applications
that are running against the other dbs are running smoothly the problem is
not at the server lelvel or at the network level?
also, opening the task mamager on the server machine I see that the cpu isnt
realy busy and that there is no paging.
I captured the a application queries with the profiler and I saw that the
cpu/ read/writes times are low.
there is no fragmentation on the indexes.
I also run the index tunning wizard with the profiler file. it indicated a
44% improvment and suggested 5 new indexes; but I still belive the problem
lays somewhere else.
and, the system guy, who is monitoring the network traffic, tells me it's
not the network as the bendwidth is 50% free.
so... where should I aim at next?
thanks,
alon.If the rest of the databases are doing fine except this one, then yes, the
problem is at the database level not at the server level.
You said, Index Tuning Wizard suggested new indexes, and the predicted
performance gain is substantial. I think you should go for it, after
testing.
To start with identify which stored procedures are running slow. Use
Profiler to identify the long running stored procedures (look at the
duration column, time is in milliseconds). once you identified the stored
procedures, try running them individually from Query Analyzer, with
'graphical execution plan' turned on. If you see index or table scans, then
the query is not written well, or there are no supporting indexes for that
query. Then try applying the indexes suggested by Index Tuning Wizard and
see if your query plan and response times improve.
Again, simply keep adding indexes is not really good for an OLTP system. if
you are trying to run report-like queries on an OLTP system, then you might
want to replicate the data to a different database, and run your queries
there. You could use transactional replication for this purpose. With
transactional replication the subscriber is only a few seconds behind the
publisher, in general.
Using Profiler, if you do find that the stored procedures and queries are
indeed running fine, the bottle neck is either the network or the
application.
Also check that there's no blockig going on in your database. You could use
sp_who or sp_who2 to see if any of the spids are getting blocked. Blocked
spid have a non-zero value in the 'blocked' column.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"alon" <alon@.discussions.microsoft.com> wrote in message
news:6467A9F4-A2C8-4EB8-9C2D-60286D564E6C@.microsoft.com...
> hi all
> I'm running a sql 2000 standard edition server on win 2000 server.
> one instance on a 3 gb memory, 2 cpus ,machine.
> there are about 20 databases on the server; however I'm encounering a
> problem with a spacific 500 mb db.
> the problem is: 7 client stations located at a different city
> communicating
> (only with)the problematic db on the server threw a single application
> via
> iis. for the last few months the respons time is queit slow. tables are
> reletivly small (the biggest is 60000 rows but the rest a only a few
> hunderd
> each)
> now... I'm trying yo isolate the problem.
> my first question: is it true to say that since the rest of the
> applications
> that are running against the other dbs are running smoothly the problem is
> not at the server lelvel or at the network level?
> also, opening the task mamager on the server machine I see that the cpu
> isnt
> realy busy and that there is no paging.
> I captured the a application queries with the profiler and I saw that the
> cpu/ read/writes times are low.
> there is no fragmentation on the indexes.
> I also run the index tunning wizard with the profiler file. it indicated a
> 44% improvment and suggested 5 new indexes; but I still belive the problem
> lays somewhere else.
> and, the system guy, who is monitoring the network traffic, tells me it's
> not the network as the bendwidth is 50% free.
> so... where should I aim at next?
> thanks,
> alon.
>

monitoring application performence

hi all
I'm running a sql 2000 standard edition server on win 2000 server.
one instance on a 3 gb memory, 2 cpus ,machine.
there are about 20 databases on the server; however I'm encounering a
problem with a spacific 500 mb db.
the problem is: 7 client stations located at a different city communicating
(only with)the problematic db on the server threw a single application via
iis. for the last few months the respons time is queit slow. tables are
reletivly small (the biggest is 60000 rows but the rest a only a few hunderd
each)
now... I'm trying yo isolate the problem.
my first question: is it true to say that since the rest of the applications
that are running against the other dbs are running smoothly the problem is
not at the server lelvel or at the network level?
also, opening the task mamager on the server machine I see that the cpu isnt
realy busy and that there is no paging.
I captured the a application queries with the profiler and I saw that the
cpu/ read/writes times are low.
there is no fragmentation on the indexes.
I also run the index tunning wizard with the profiler file. it indicated a
44% improvment and suggested 5 new indexes; but I still belive the problem
lays somewhere else.
and, the system guy, who is monitoring the network traffic, tells me it's
not the network as the bendwidth is 50% free.
so... where should I aim at next?
thanks,
alon.If the rest of the databases are doing fine except this one, then yes, the
problem is at the database level not at the server level.
You said, Index Tuning Wizard suggested new indexes, and the predicted
performance gain is substantial. I think you should go for it, after
testing.
To start with identify which stored procedures are running slow. Use
Profiler to identify the long running stored procedures (look at the
duration column, time is in milliseconds). once you identified the stored
procedures, try running them individually from Query Analyzer, with
'graphical execution plan' turned on. If you see index or table scans, then
the query is not written well, or there are no supporting indexes for that
query. Then try applying the indexes suggested by Index Tuning Wizard and
see if your query plan and response times improve.
Again, simply keep adding indexes is not really good for an OLTP system. if
you are trying to run report-like queries on an OLTP system, then you might
want to replicate the data to a different database, and run your queries
there. You could use transactional replication for this purpose. With
transactional replication the subscriber is only a few seconds behind the
publisher, in general.
Using Profiler, if you do find that the stored procedures and queries are
indeed running fine, the bottle neck is either the network or the
application.
Also check that there's no blockig going on in your database. You could use
sp_who or sp_who2 to see if any of the spids are getting blocked. Blocked
spid have a non-zero value in the 'blocked' column.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"alon" <alon@.discussions.microsoft.com> wrote in message
news:6467A9F4-A2C8-4EB8-9C2D-60286D564E6C@.microsoft.com...
> hi all
> I'm running a sql 2000 standard edition server on win 2000 server.
> one instance on a 3 gb memory, 2 cpus ,machine.
> there are about 20 databases on the server; however I'm encounering a
> problem with a spacific 500 mb db.
> the problem is: 7 client stations located at a different city
> communicating
> (only with)the problematic db on the server threw a single application
> via
> iis. for the last few months the respons time is queit slow. tables are
> reletivly small (the biggest is 60000 rows but the rest a only a few
> hunderd
> each)
> now... I'm trying yo isolate the problem.
> my first question: is it true to say that since the rest of the
> applications
> that are running against the other dbs are running smoothly the problem is
> not at the server lelvel or at the network level?
> also, opening the task mamager on the server machine I see that the cpu
> isnt
> realy busy and that there is no paging.
> I captured the a application queries with the profiler and I saw that the
> cpu/ read/writes times are low.
> there is no fragmentation on the indexes.
> I also run the index tunning wizard with the profiler file. it indicated a
> 44% improvment and suggested 5 new indexes; but I still belive the problem
> lays somewhere else.
> and, the system guy, who is monitoring the network traffic, tells me it's
> not the network as the bendwidth is 50% free.
> so... where should I aim at next?
> thanks,
> alon.
>

monitoring application performence

hi all
I'm running a sql 2000 standard edition server on win 2000 server.
one instance on a 3 gb memory, 2 cpus ,machine.
there are about 20 databases on the server; however I'm encounering a
problem with a spacific 500 mb db.
the problem is: 7 client stations located at a different city communicating
(only with)the problematic db on the server threw a single application via
iis. for the last few months the respons time is queit slow. tables are
reletivly small (the biggest is 60000 rows but the rest a only a few hunderd
each)
now... I'm trying yo isolate the problem.
my first question: is it true to say that since the rest of the applications
that are running against the other dbs are running smoothly the problem is
not at the server lelvel or at the network level?
also, opening the task mamager on the server machine I see that the cpu isnt
realy busy and that there is no paging.
I captured the a application queries with the profiler and I saw that the
cpu/ read/writes times are low.
there is no fragmentation on the indexes.
I also run the index tunning wizard with the profiler file. it indicated a
44% improvment and suggested 5 new indexes; but I still belive the problem
lays somewhere else.
and, the system guy, who is monitoring the network traffic, tells me it's
not the network as the bendwidth is 50% free.
so... where should I aim at next?
thanks,
alon.
If the rest of the databases are doing fine except this one, then yes, the
problem is at the database level not at the server level.
You said, Index Tuning Wizard suggested new indexes, and the predicted
performance gain is substantial. I think you should go for it, after
testing.
To start with identify which stored procedures are running slow. Use
Profiler to identify the long running stored procedures (look at the
duration column, time is in milliseconds). once you identified the stored
procedures, try running them individually from Query Analyzer, with
'graphical execution plan' turned on. If you see index or table scans, then
the query is not written well, or there are no supporting indexes for that
query. Then try applying the indexes suggested by Index Tuning Wizard and
see if your query plan and response times improve.
Again, simply keep adding indexes is not really good for an OLTP system. if
you are trying to run report-like queries on an OLTP system, then you might
want to replicate the data to a different database, and run your queries
there. You could use transactional replication for this purpose. With
transactional replication the subscriber is only a few seconds behind the
publisher, in general.
Using Profiler, if you do find that the stored procedures and queries are
indeed running fine, the bottle neck is either the network or the
application.
Also check that there's no blockig going on in your database. You could use
sp_who or sp_who2 to see if any of the spids are getting blocked. Blocked
spid have a non-zero value in the 'blocked' column.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"alon" <alon@.discussions.microsoft.com> wrote in message
news:6467A9F4-A2C8-4EB8-9C2D-60286D564E6C@.microsoft.com...
> hi all
> I'm running a sql 2000 standard edition server on win 2000 server.
> one instance on a 3 gb memory, 2 cpus ,machine.
> there are about 20 databases on the server; however I'm encounering a
> problem with a spacific 500 mb db.
> the problem is: 7 client stations located at a different city
> communicating
> (only with)the problematic db on the server threw a single application
> via
> iis. for the last few months the respons time is queit slow. tables are
> reletivly small (the biggest is 60000 rows but the rest a only a few
> hunderd
> each)
> now... I'm trying yo isolate the problem.
> my first question: is it true to say that since the rest of the
> applications
> that are running against the other dbs are running smoothly the problem is
> not at the server lelvel or at the network level?
> also, opening the task mamager on the server machine I see that the cpu
> isnt
> realy busy and that there is no paging.
> I captured the a application queries with the profiler and I saw that the
> cpu/ read/writes times are low.
> there is no fragmentation on the indexes.
> I also run the index tunning wizard with the profiler file. it indicated a
> 44% improvment and suggested 5 new indexes; but I still belive the problem
> lays somewhere else.
> and, the system guy, who is monitoring the network traffic, tells me it's
> not the network as the bendwidth is 50% free.
> so... where should I aim at next?
> thanks,
> alon.
>

Monitor MemToLeave usage

Hi,
I am interested in detecting possible memory leaks in extended store
procedures.
Is there a way to monitor MemToLeave usage ?
setup:
win2k advanced server sp4 (cluster)
sql server 2000 advanced server sp3a
AWE + PEA
Total mem 7Gb
Mem for sql server 6Gb
/Jan
We use a combination of VMSTAT.EXE to get the total free and xp_memory_size
(comes with SQL Litespeed) to get the max contiguous block. We use these to
populate 2 of the user settable SQL counters so that we can monitor the
levels and raise alerts if the max contiguous block falls below 5MB which
allows us enough time to schedule a restart of the instance.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jan Ahlbeck" <NoSpam@.dk.dk> wrote in message
news:OB%23ULJ8VFHA.2960@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I am interested in detecting possible memory leaks in extended store
> procedures.
> Is there a way to monitor MemToLeave usage ?
> setup:
> win2k advanced server sp4 (cluster)
> sql server 2000 advanced server sp3a
> AWE + PEA
> Total mem 7Gb
> Mem for sql server 6Gb
> /Jan
>

Monitor MemToLeave usage

Hi,
I am interested in detecting possible memory leaks in extended store
procedures.
Is there a way to monitor MemToLeave usage ?
setup:
win2k advanced server sp4 (cluster)
sql server 2000 advanced server sp3a
AWE + PEA
Total mem 7Gb
Mem for sql server 6Gb
/JanWe use a combination of VMSTAT.EXE to get the total free and xp_memory_size
(comes with SQL Litespeed) to get the max contiguous block. We use these to
populate 2 of the user settable SQL counters so that we can monitor the
levels and raise alerts if the max contiguous block falls below 5MB which
allows us enough time to schedule a restart of the instance.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jan Ahlbeck" <NoSpam@.dk.dk> wrote in message
news:OB%23ULJ8VFHA.2960@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I am interested in detecting possible memory leaks in extended store
> procedures.
> Is there a way to monitor MemToLeave usage ?
> setup:
> win2k advanced server sp4 (cluster)
> sql server 2000 advanced server sp3a
> AWE + PEA
> Total mem 7Gb
> Mem for sql server 6Gb
> /Jan
>

Monitor MemToLeave usage

Hi,
I am interested in detecting possible memory leaks in extended store
procedures.
Is there a way to monitor MemToLeave usage ?
setup:
win2k advanced server sp4 (cluster)
sql server 2000 advanced server sp3a
AWE + PEA
Total mem 7Gb
Mem for sql server 6Gb
/JanWe use a combination of VMSTAT.EXE to get the total free and xp_memory_size
(comes with SQL Litespeed) to get the max contiguous block. We use these to
populate 2 of the user settable SQL counters so that we can monitor the
levels and raise alerts if the max contiguous block falls below 5MB which
allows us enough time to schedule a restart of the instance.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jan Ahlbeck" <NoSpam@.dk.dk> wrote in message
news:OB%23ULJ8VFHA.2960@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I am interested in detecting possible memory leaks in extended store
> procedures.
> Is there a way to monitor MemToLeave usage ?
> setup:
> win2k advanced server sp4 (cluster)
> sql server 2000 advanced server sp3a
> AWE + PEA
> Total mem 7Gb
> Mem for sql server 6Gb
> /Jan
>