lose data

In my applications (web version and client version)
sometime my users in the day after loss data!
I think are a transaction problem but
I don't know why...
Have you any suggests for my problem...
thank to all
Pippo
2 things you might try...
Run Profiler to capture inserts, updates, and deletes to see what is going
on. or
use Lumigents tool ( Log Exploerer) to search the transaction log and do the
same thing.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"PIPPO" <anonymous@.discussions.microsoft.com> wrote in message
news:118a01c4ab8f$00744770$a601280a@.phx.gbl...
> In my applications (web version and client version)
> sometime my users in the day after loss data!
> I think are a transaction problem but
> I don't know why...
> Have you any suggests for my problem...
> thank to all
> Pippo
|||- check for rollback of transactions
- check also if some process is updating your initial rows.

>--Original Message--
>2 things you might try...
>Run Profiler to capture inserts, updates, and deletes to
see what is going
>on. or
>use Lumigents tool ( Log Exploerer) to search the
transaction log and do the
>same thing.
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Mariner, Charlotte, NC
>www.mariner-usa.com
>(Please respond only to the newsgroups.)
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>"PIPPO" <anonymous@.discussions.microsoft.com> wrote in
message
>news:118a01c4ab8f$00744770$a601280a@.phx.gbl...
>
>.
>

lose data

In my applications (web version and client version)
sometime my users in the day after loss data!
I think are a transaction problem but
I don't know why...
Have you any suggests for my problem...
thank to all
Pippo2 things you might try...
Run Profiler to capture inserts, updates, and deletes to see what is going
on. or
use Lumigents tool ( Log Exploerer) to search the transaction log and do the
same thing.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"PIPPO" <anonymous@.discussions.microsoft.com> wrote in message
news:118a01c4ab8f$00744770$a601280a@.phx.gbl...
> In my applications (web version and client version)
> sometime my users in the day after loss data!
> I think are a transaction problem but
> I don't know why...
> Have you any suggests for my problem...
> thank to all
> Pippo|||- check for rollback of transactions
- check also if some process is updating your initial rows.
>--Original Message--
>2 things you might try...
>Run Profiler to capture inserts, updates, and deletes to
see what is going
>on. or
>use Lumigents tool ( Log Exploerer) to search the
transaction log and do the
>same thing.
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Mariner, Charlotte, NC
>www.mariner-usa.com
>(Please respond only to the newsgroups.)
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>"PIPPO" <anonymous@.discussions.microsoft.com> wrote in
message
>news:118a01c4ab8f$00744770$a601280a@.phx.gbl...
>> In my applications (web version and client version)
>> sometime my users in the day after loss data!
>> I think are a transaction problem but
>> I don't know why...
>> Have you any suggests for my problem...
>> thank to all
>> Pippo
>
>.
>sql

Looking for tools to monitor sql and applications

I am looking for the right tools to do application monitoring.

I'm hoping to find one single tool that can do the entire job but if
it does not exist then a few monitoring apps would do as well.

I need the ability to do the standard things like testing for ping,
checking for windows services running and restarting them after some
threshold is met, and wmi.

Some of the more tricky things I need it to do are:

* Parse log files looking for specific error codes, and the ability to
set an alert only if it sees that error X times over some period of
time.

* Run custom slq queries like row counts and max values returned from
a query and if that condition is met X times over some period of
time.

* Run an external app that does its own custom testing and act on its
results, which could be to parse the result file from the app.

Keep in mind cost is not the isssue right now - so this can be
freeware to some type of enterprise solution that our company can use.
Does anyone know of any tools that you can point me towards?

Thanks...(reg@.yahoo.com) writes:
> I am looking for the right tools to do application monitoring.
>
> I'm hoping to find one single tool that can do the entire job but if
> it does not exist then a few monitoring apps would do as well.
>
> I need the ability to do the standard things like testing for ping,
> checking for windows services running and restarting them after some
> threshold is met, and wmi.
> Some of the more tricky things I need it to do are:
>
> * Parse log files looking for specific error codes, and the ability to
> set an alert only if it sees that error X times over some period of
> time.
> * Run custom slq queries like row counts and max values returned from
> a query and if that condition is met X times over some period of
> time.
> * Run an external app that does its own custom testing and act on its
> results, which could be to parse the result file from the app.
>
> Keep in mind cost is not the isssue right now - so this can be
> freeware to some type of enterprise solution that our company can use.
> Does anyone know of any tools that you can point me towards?

Have you looked at Microsoft Operations Manager? I can't tell that it
does all you want, but MOM is the tool Microsoft presents when you
need to monitor many servers. (It is not really clear from your post
that is what you want, though.)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Looking for simple sample

Hello

I'm looking around for tutorials and samples for Notification Services applications for a while now, but I just can't find something that covers what I want to do. All I want is to check if a value in my Database changes or exceeds a specific value and then send a mail.

Does anyone know a good sample that show's me how to do this or can anyone explain it in a couple of words?

Thanks in advance!

This is a fairly common scenario. Use the SQL Server Event Provider to query your database table, looking for new or changed records. In your Subscription Class, have each subscriber specify the threshold they are interested in and in the match rule compare the two to produce the notifications.

The Stock sample application that comes with SSNS would be an excellent place to start. Just replace the FileSystemWatcher Event Provider with the SQL Server Event Provider and you're most of the way there.

You'll probably want to use at least one Chronicles table to prevent unwanted/uninteresting notifications. For example, if the threshold is continually exceeded, you probably don't want to continually email your subscribers. To use the Stock sample to illustrate: if I want to know when Microsoft's stock exceeds $45/share. No big deal. But if on 5 consecutive generator firings the stock values are $44.90, $45.10, $45.20, $45.50, and $46.00, without careful planning you will have just generated 4 emails to me. To prevent the unwanted notifications, use the chronicles table - either keep track of the highwater mark, or the fact that you've already sent out a notification, or whatever makes the most sense in your situation. BTW - if you have a copy of my book, I discuss this in Chapter 7, but I'll be glad to continue the conversation here, too.

HTH...

Joe