Showing posts with label monitor. Show all posts
Showing posts with label monitor. Show all posts

Friday, March 30, 2012

How to develop a program which can monitor the change of a table content?

I need this exe program to monitor the insert and update action of a
table in SQL Server 2000 initiatively
How to delevop this program?
Who can provide me some advice or some information?
Thanks a lot.This is a multi-part message in MIME format.
--=_NextPart_000_0051_01C3CAB1.5A9963D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
See my reply in .programming.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
.
"Simon Peng" <pengxq@.hotmail.com> wrote in message
news:tpcluvo1vuac96vtrplv36sndhoiheg9ck@.4ax.com...
I need this exe program to monitor the insert and update action of a
table in SQL Server 2000 initiatively
How to delevop this program?
Who can provide me some advice or some information?
Thanks a lot.
--=_NextPart_000_0051_01C3CAB1.5A9963D0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

See my reply in =.programming.
-- Tom
----Thomas A. =Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql.
"Simon Peng" wrote in =message news:tpcluvo1vua=c96vtrplv36sndhoiheg9ck@.4ax.com...I need this exe program to monitor the insert and update action of =atable in SQL Server 2000 initiativelyHow to delevop this program?Who can =provide me some advice or some information?Thanks a lot.

--=_NextPart_000_0051_01C3CAB1.5A9963D0--|||Why dont you use triggers to audit the table|||sysindexes table records all update, insert, delete activity for all tables. this may work for you. check it out.sql

Friday, March 23, 2012

how to determine how many users web sql will support?

Hello,
We are writting a small pc monitor app that sends pc statistics (hd free,
mem free etc) to a hosted sql server every hour. The pc's also do a select
query to see if there are any messages for it every 30 seconds. We may have
up to 1000 computers doing this. How do I make sure our hosted SQL server
can handle this performance wise?
My other concern is that all 1000 will hit the sql at nearly the same time
cause extreme delays. Any suggestions?
Thanks!
Matt
> up to 1000 computers doing this. How do I make sure our hosted SQL server
> can handle this performance wise?
There is no magic formula, it will depend on a number of things, such as
amount of data being transferred, bandwidth, hardware, table
structure/indexes, concurrency of inserts, concurrency of inserts/updates
vs. selects, etc. I suggest you look into some load testing software, e.g.
there is a list here for web-based apps http://www.aspfaq.com/2139
For the database specifically, you can use profiler, Database Hammer from
the SQL Server 2000 Resource Kit, SQL Load Simulator 2.0 (SQLLS2) that comes
with the Back Office Resource Kit 4.5, or some of these:
http://www.mercury.com/us/products/performance-center/
http://www.benchmarkfactory.com/comm...tent.asp?PID=1
http://www-306.ibm.com/software/awdt...nce/index.html
http://www.sqlpower.com/products.html

how to determine how many users web sql will support?

Hello,
We are writting a small pc monitor app that sends pc statistics (hd free,
mem free etc) to a hosted sql server every hour. The pc's also do a select
query to see if there are any messages for it every 30 seconds. We may have
up to 1000 computers doing this. How do I make sure our hosted SQL server
can handle this performance wise?
My other concern is that all 1000 will hit the sql at nearly the same time
cause extreme delays. Any suggestions?
Thanks!
Matt> up to 1000 computers doing this. How do I make sure our hosted SQL server
> can handle this performance wise?
There is no magic formula, it will depend on a number of things, such as
amount of data being transferred, bandwidth, hardware, table
structure/indexes, concurrency of inserts, concurrency of inserts/updates
vs. selects, etc. I suggest you look into some load testing software, e.g.
there is a list here for web-based apps http://www.aspfaq.com/2139
For the database specifically, you can use profiler, Database Hammer from
the SQL Server 2000 Resource Kit, SQL Load Simulator 2.0 (SQLLS2) that comes
with the Back Office Resource Kit 4.5, or some of these:
http://www.mercury.com/us/products/performance-center/
http://www.benchmarkfactory.com/com...ntent.asp?PID=1
http://www-306.ibm.com/software/awd...ance/index.html
http://www.sqlpower.com/products.htmlsql

how to determine how many users web sql will support?

Hello,
We are writting a small pc monitor app that sends pc statistics (hd free,
mem free etc) to a hosted sql server every hour. The pc's also do a select
query to see if there are any messages for it every 30 seconds. We may have
up to 1000 computers doing this. How do I make sure our hosted SQL server
can handle this performance wise?
My other concern is that all 1000 will hit the sql at nearly the same time
cause extreme delays. Any suggestions?
Thanks!
Matt> up to 1000 computers doing this. How do I make sure our hosted SQL server
> can handle this performance wise?
There is no magic formula, it will depend on a number of things, such as
amount of data being transferred, bandwidth, hardware, table
structure/indexes, concurrency of inserts, concurrency of inserts/updates
vs. selects, etc. I suggest you look into some load testing software, e.g.
there is a list here for web-based apps http://www.aspfaq.com/2139
For the database specifically, you can use profiler, Database Hammer from
the SQL Server 2000 Resource Kit, SQL Load Simulator 2.0 (SQLLS2) that comes
with the Back Office Resource Kit 4.5, or some of these:
http://www.mercury.com/us/products/performance-center/
http://www.benchmarkfactory.com/common/content.asp?PID=1
http://www-306.ibm.com/software/awdtools/tester/performance/index.html
http://www.sqlpower.com/products.html