Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server CE / September 2007

Tip: Looking for answers? Try searching our database.

FlushFailure event on Remote performance monitor

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Simone - 24 Sep 2007 15:36 GMT
Hi all.

I'm testing my C# application on the SqlServer CE 3.1. The sdf file is in
the Secure Digital.
When i want to query the database i make a new Sqlceconnection Object, then
i Open,Close and dispose that.

In the remote performance monitor i see (correctly) a big number of
SqlCeconnection Objects that is expecting Garbage collector. (In fact when
garbage collector runs the instancies of SqlCe disappear from the list of
the Remote performance monitor).
I see also a number of the FlushFailureEvantHandler instancies. This number
is the same of the SqlCeConnection instancies. (Also these instancies are
collected when Garbage Collector runs)
Why there is the FlushFailureEventHandler instancies? What is their meaning?

Another question:

The connection string of my SqlCeConnection objects don't have the flush
interval parameter so the default is 10 seconds. If i have the sdf on the
Secure Digital and my pocket go in suspend mode during the flush event there
is the possibility of the database corruption?
Is a good idea set the flush interval parameter at the minimum value (1
second)?

Thanks in advance.

Simon.
ErikEJ - 24 Sep 2007 16:21 GMT
FlushFailure occurs when the Flush fails!

http://msdn2.microsoft.com/en-us/library/system.data.sqlserverce.sqlceconnection
.flushfailure.aspx


Subscribing to this event allows you to handle a flush failure. Lowering the
flush interval will affect performance but increase data integrity - so it
will be a tradeoff based on your data access pattern and application
requirements.

Signature

Erik Ejlskov Jensen, Mobile App Dev MCTS
Check out my SQL Compact blog at
http://erikej.blogspot.com

> Hi all.
>
[quoted text clipped - 25 lines]
>
> Simon.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.