SqlDependency / Want To Use It To Monitor Several Tables (around 10)
Aug 6, 2010
I'm using SqlDependency to control my cache. I want to use it to monitor several tables (around 10). There should be one SqlDependency per watched table.
Should I create for each of them code like that:
public void CreateDependency_Table()
{
if (connectionStringSettings != null) [code]....
or can I reuse something between them? Like connection?Is this the preferred way of setting multiple notifications?
I have a producer-consumer scenario in ASP.NET. I designed a Producer class, a Consumer class and a class for holding the shared objects and responsible for communication between Producer and Consumer, lets call it Mediator. Because I fork the execution path at start-up (in parent object) and one thread would call Producer.Start() and another thread calls Consumer.Start(), I need to pass a reference of Mediator to both Producer and Consumer (via Constructor). Mediator is a smart class which will optimize many things like length of it's inner queue but for now consider it as a circular blocking queue. Producer would enqueues new objects to Mediator until the queue gets full and then Producer would block. Consumer dequeues objects from Mediator until there's nothing in the queue. For signaling between threads, I implemented two methods in Mediator class: Wait() and Pulse(). The code is something like this:
Class Mediator { private object _locker = new object();[code]....
Inside Mediator I use this.Pulse() every time something is Enqueued or Dequeued so waiting threads would be signaled and continue their work.But I encounter deadlocks and because I have never used this kind of design for signaling threads, I'm not sure if something is wrong with the design or I'm doing something wrong elsewhere ?
When I implement a SqlDependency watcher in a windows form, everything works fine as long as I invoke my "OnChance" event to the ui thread.
private void dependency_OnChange(object sender, SqlNotificationEventArgs e) { if (this.InvokeRequired)[code]....
The same happens when I comment these lines in the windowsform, so I think that the _OnChance Event is on a different thread than the "thread" I'm using when I call SetSqlWatcher the first time.
I also tried to implement ISynchronizeInvoke (with the help of GenericSynchronizingObject in libary http://nitoasync.codeplex.com). I debugged, saw, that the code has to invoke it the first time, but it also hangs in "SqlDependency.Stop"...
What are the key differences between these and when should they be used? My initial understanding was that SqlCacheDependency used polling but I've read it doesn't have too for ASP.NET 2.0. I want to know which is most appropriate for caching of linq queries under ASP.NET web server. This will be ASP.NET 3.5.
I put a sqldependency in my application but the onchanged event does not fire, I tried to put some breakpoints and it thru to the label1.text = "Changed".
I have a small app that is used to register users to the system. I am interested in having a log that will tell me, who - userid that logs in, what they do, how long. meaning, the rows they look at or update. I suppose to make a small table for this logging. lets assume a small table with only 2 columns, timestamp and the userid. It would be good to get some kind of ip address for identity.
the other parts will begood to know and interesting to learn how to code but less critical.
the signon.aspx you can see here. Is this where to code
i have one software in asp.net..once the user login to the software.then only user can acces the desktop and i want to monitor all the the works done by the user in my asp.net software .
Can I objectively determine if my production ASP.NET web application is resetting its application pool? It could be for whatever reason (for example, an error occurred or memory topped off). I don't have direct access to my production servers, so when I want something on the server, I have ask specifically for it like PerfMon counters to run. It is a running IIS 6.0. I understand that I could use PerfMon to catch ASP.NET Application Restarts. If I was not monitoring that PerfMon, is there anything that can tell me the application restarted sometime in the past?
I have built a web page that does a complex processing, and I realized recently that I need to convert it to a windows service running at the background and keeping the web page for monitoring and initiating the service.
The service will process some files, and provides information messages to the user.
I'm not sure how to implement the link between the windows service and the web site, but i was trying to avoid using MSMQ to connect both application together.
I have a large web application, which is supposed to run in a 64 bit process. However, when I set "Enable 32-bit Applications" to False on my App Pool, I get the following error trying to run the app in IE:
is not a valid Win32 application. (Exception from HRESULT: 0x800700C1)
The application name at he beginning of the error message is missing, i.e. I have not lost it during copy and paste.
I have been advised to use Process Monitor to determine which application/DLL load is actually causing the error, but I have no idea where to start with this.
EDIT: I have tried filtering Process Monitor on only w3wp.exe and only file system and process events, but simply attempting a navigate to the root URL yields 34,012 events.
isnt there performance analysis tools that i can use to monitor and trouble shoot things like timeout expired (slow query execution)?
I mean is there a way for me to monitor the query performance as it is run from the webpage. It runs perfectly in the SMS but it's slow when it's running from the webpages so it throws Timeout expired exception.
We have been assigned a project for future developement. The problem is original developer did not create any data model, so we are in trouble understanding how db structure flow goes. I know we can create database diagram (even did that), but db contains 162 tables so the db diagram becomes so big that it does not fit in the monitor's view. Viewing each table > keys (for relationships) is not possible.
I would like to monitor the entire project through the clicks. For example if i open a new page and clicking any control it should get monitored like ( User x clicked this many events on this page )
I want to implement a response time monitor in a ASP.Net application. This monitor has to calculate the average response time during 2 secs. Whats the performance counter i can use. I tried ASP.NET ApplicationsRequests/Sec but did not work. Whats the best way to do this. I am using the default server formed by VS2005 for development, does this affect the performance counter programming?
Where should I implement the logic? Global.ASAX? in every 2 sec i want to check this value and make some decisions.
In addition, what are the parameters I can alter in a ASP.Net application at runtime to improve perfromance. How can I change them?
Is there any way to monitor asp.net session state in order to watch object size, or is there any other practice to find out a way to lighten asp.net session?
I have an C# ASP application I am writing that needs to have the capability to import a generated excel or a comma delineated sheet each day. A clerk will have this job each morning so it doesn't need to be automated. My problem in trying to understand the solution to this is that the 1 sheet contains loan information, including customer information all in the same sheet. I would like to send certain columns to update information in the loan table and send other information to update the customer table. I need it to create relationships when new loans appear in the spreadsheet.
I am using bulk insert concept to export the data from dat file to tables(Two tables). I am using the temporary table for to do the calculation and insertion to two tables. My problem is whenever I selecting the temp table data after the execution of bulk insertion , the order is changing .I need to get the order as it is in file order(csv,dat,txt).
