Monitoring SQL Compact Edition Performance
Aug 24, 2007Does SQL Compact Edition expose performance counters to tools like Perfmon as SQL Server does? For instance, can you view lock wait times, cache hit ratio, etc.?
View 1 Replies
ADVERTISEMENT
SQL 2012 :: Monitoring Tool Using Powershell And Performance Monitoring
Sep 15, 2014We are in plan to build a Monitoring tool using PowerShell and Performance Monitor which could monitor 10 to 20 servers. Do you have any reference of any existing tool using Performance Monitor to monitor the SQL Server and available for free? I didn't want to put some effort, if something is available already.
View 2 Replies View RelatedSqlceoledb35.dll - Error 25123 - A SQL Server Compact Edition DLL Could Not Be Loaded. Reinstall SQL Server Compact Edition.
May 5, 2008Hello,
we've got a SQL Server 2005 which replicates with an SQL Server Compact 3.5. Every 10 to 20 synchronisations we're getting the error mentioned above. A Soft reset of the device helps to make the synchronization working again.
Why is this error happening and how can we resolve this?
BTW, we've also running system that replicates with an SQL Server Compact 3.0 without having this problems.
Thanks,
Markus
A Sql Server Compact Edition DLL Could Ot Be Loaded Reinstall SQL Server Compact Edition [ DLL Name = Sqlceca30.dll]
Mar 11, 2008
Hi there,
everything is ok for first run. but i leave the program relogin
than that error occured ppc2003 second edition devices. Windows mobile 5.0 device works fine.
can anybody help me?
VS2005 ver 8.0.50727
SSCE31VSTools-ENU.exe loaded
SSCE31SDK-ENU.msi loaded
machine 1
SQL 2005 loaded
machine 2
http://192.168.20.22/ssce/sqlcesa30.dll
"Microsoft SQL Server Compact Edition Server Agent" looks fine
pocket pc side
C:Program FilesMicrosoft SQL Server Compact Editionv3.1SDKinwce400armv4
.net cf 2.0 sp2
sqlce30.dev.ENU.ppc.wce4.armv4.CAB
sqlce30.ppc.wce4.armv4.CAB
sqlce30.repl.ppc.wce4.armv4.CAB installed too.
my code
---------------------------------------------
Dim RdaStr As String = "Provider=SQLOLEDB; Data Source=" + Server + ";Initial Catalog=" + DataBase + ";Integrated Security=SSPI"
Dim rda As SqlCeRemoteDataAccess
Try
rda = New SqlCeRemoteDataAccess "THIS LINE GIVES ME THAT ERROR
Catch ex As Exception
MsgBox(ex.ToString)
Application.Exit()
End Try
Try
rda.InternetLogin = [String].Empty
rda.InternetPassword = [String].Empty
rda.InternetUrl = "http://" + IP_no + "/ssce/sqlcesa30.dll"
rda.LocalConnectionString = ConnectString
Catch ex As Exception
MsgBox("Bağlantı hatası..")
Application.Exit()
End Try
------------------------------------------------------------------------------
i added the following code to very beginning of my code too.
that code lock my device
Declare Function LoadLibrary Lib "coredll" Alias "LoadLibrary" (ByVal lpLibFileName As String) As IntPtr
Dim pt As IntPtr
pt = LoadLibrary("\windowssqlceca30.dll")
pt = LoadLibrary("\windowssqlceoledb30.dll")
pt = LoadLibrary(\windowssqlcecompact30.dll)
-----------------------------------------------------------------------------
SQL 2008 Developer Edition Management Studio Does Not Work For Compact Edition 3.5 Databases
Sep 27, 2007
I am attempting to use the SQL Server 2008 Developer Edition (Management Studio) to create/manage a Compact Edition 3.5 database. My problem is that I cannot even create/open the compact database in Management Studio. Any help would be GREATLY appreciated. TIA
Problem Creating the Compact Database:
Open 2008 Management Studio
From menu choose File | Connect Object Explorer...
Choose SQL Server Compact Edition as the Server type.
Choose <New Database...> as the Database file.
Browse to folder where file will be created (C:MyDatabase#1.sdf was used in my example)
Leave all other field as default selections OR make changes, either way it does not work.
Click OK.
At this point the OK button just becomes disabled and nothing happens.
Problem Opening An Existing Compact Database:
Open 2008 Management Studio
From menu choose File | Connect Object Explorer...
Choose SQL Server Compact Edition as the Server type.
Choose <Browse for more...> as the Database file and locate a ".sdf" file that I created using VS2008.
Enter password, if any.
Click OK.
The following exception is displayed:
TITLE: Connect to Server
------------------------------
Cannot connect to C:Documents and SettingsdarrinbMy DocumentsVisual Studio 2008ProjectsTestSQLCompactEdition35TestSQLCompactEdition35AFS.sdf.
------------------------------
ADDITIONAL INFORMATION: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Could not load file or assembly 'Microsoft.SqlServerCe.Enumerator, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) (mscorlib)
------------------------------
BUTTONS: OK
------------------------------
Move Data Between The SQL Compact Edition And SQL Express Edition, Is This Possible??
Nov 14, 2007Hello everybody,
Wrote before but did not go any answer , try again.
I have two question about SQL compact edition (SQLCE) (.sdf) and SQL Express edition (SQLED) (.mdf).
I have been testing SQLED and have many tables and data in it.
I want know to test SQLCD and hopefully be able to communicate with the SQLED.
For this reason I was wondering the following:
1. IIs it possible to move all the tables and it constratints into the SQLCE from the SQED ?
2. Another possibility I was thinking about was to use some tables in the SQLED in the SQLCE and move data between these two databases through RDA .
However, does this two versions aloud this kind of communciation...between them....?
Thanks in forehand,
Matilde
Difference Of Compact Edition And Mobile Edition
Aug 19, 2007Hello
I recently downloaded the sql mobile edition, and then I found out about the compact edition.
I understand that these are relational lite version of sql server that can run on mobile devices.
However, what is the difference between the CF and mobile edition? Why should I choice one over the other?
I have just heard about sql everywhere, seems there are all these edtions and how would you choice the right tool for the right job?
Many thanks if someone could explain further,
Steve
Performance Monitoring
Apr 5, 2000Hi,
I am new to sql server and sould like to know how I can monitor the server performance on sql servers 6.5 and 7. In sybase we can run sp_sysmon. Is there anything similar to this for sql server.
Thanks.
Performance Monitoring
Apr 17, 2000Hi
I am learning SQL SERVER ..Can anyone tell me how do I tune a given stored procedure in 6.5 and 7.0.?
In performance tunning which counters are really necessary to watch and the remedies to be taken?
Thanks
Reddy
Performance Monitoring
Mar 8, 1999Does anyone know of a way to determine which SPs or which tables are being accessed the most heavily or often from an application? I have inherited a site that is heavily used, but poorly tuned. However we have distributed C/S apps that hit the server and do not contain debug code. In addition, the SPs are encrypted and I do not want to replace them in the short term with new SPs that log hits.
I realize I can use triggers, but is there any other method?
Performance Monitoring
Jan 13, 2004Hi,
I want to collect performance measures regarding the import of data
and the growth of resulting extract_tables.
I use - say - 15 tables from a erp-system (like JDE Edwards)
to build a -say - sales-warehouse and a MS-OLAP-cube.
For every incoming table I got a dts-package witch is
protocolled into msdb.sysdtspackagelog.
Every package got the name
[Build]_[Subsystem]_[Table_name]
e.g. JDEdwards_Sales_F0005
The destination table is namend e.g. extr_F0005
Now:
With a seperate DTS-package I transport the
records from msdb-db into my build-db
- say - JDEdwardsExtract.
Name: extr_performance_monitor
(eventually filter on buildname, because there are several builds in
my system)
So this result is quit good and easy to handle for
seeing elapsed time per day.
But the dtslog won't tell me, how many records the dtspackage
had to copy.(and there is one at least with no records (Cubeupdate))
Now the count(*) comes in.
In the dts-package
sys...log ---- to --- extr_performance_monitor
I added the columns
extr_table_name,
extr_table_rowcount,
extr_table_timestamp.
With
select name, 'extr_' + replace(name, '[Build]_[Subsystem]','') as
extr_table_name from extr_performance_monitor
I cut the original dts packagename down to the extr_.. name.
But I don't have a clue how to solve the count(*)
Example:
dts_package_name,.... , extr_table_name,extr_table_rowcount, extr_table_timestamp
[Build]_[SS]_[F0005], ..., extr_F0005, 0, sysdate.
I think about a package wich is running after the last
data_import (and cube_refresh) is done.
(but the same day)
So the result could be:
Table_name (as dimension category)
Time to perform
Number of records in import table
Records per second.
The next step could be to look for required space.
The result should be a grafik - say - over 12 month
were you can easily see the amount of data performend
time consumend, (table space used),
and - very important -
you could extrapolate your hardware requirements.
Looking forward for any hints.
Thanks in advance.
Michael
Performance Monitoring?
Apr 14, 2004My SQL Server 2000 system is pegged. Disk activity is maxed out and system is very unresponsive. Several people have database tasks running through this system and I'm pretty sure there is a single application that is the culprit and I'd like to identify which one.
Does anyone have any practical tips on using "Process Info" in Enterprise Manager? What units are CPU and Physical I/O displayed in? Why does the column sort on these fields not work as expected?
Do I just pick the process with the largest Physical I/O and assume that's the problem?
Need Help On Performance Monitoring
Jul 20, 2005I was wondering if the CPU is the bottleneck. Hence I used the PerformanceMonitor to look up some values. Here are the results.Counter Scale Average MaximumMinimum%Disk Time 1 2.74 24.9320Current Disk Queue Length 10 0.090 6 0Buffer cache hit ratio 1 99.752 99.75299.751%Processor Time (Total) 1 2.307 9.6880.313%Processor Time (sqlserv) 1 1.218 7.188 0Processor Queue Length 10 6.960 11 5The thing that puzzles me is that the Processor Time is quite low but theProcessor Queue Length is very high. Why is the processor processes queuingup when the processor not bogged down ? I would assume both values to be onthe high side. Is the high buffer hit ratio an indicator that the CPU iswaiting for some reads from the buffer before processing the next process?The users often run reports on historical data. That might be the reason forthe high buffer hit rates.Am I monitoring the wrong values ?Any advise would be very much appreciated and thanks in advance.Pit
View 1 Replies View RelatedMobile Edition Vs. Compact Edition
Dec 11, 2007Hello,
there are some limitations in SQL Server 2005 Mobile Edition - e.g. there is no TRUNCATE TABLE statement, the UPDATE .. FROM clause is not allowed etc. Are these limitations in Compact Edition too? Is T-SQL in these editions functionally equal or different? Is there any comparison of T-SQL features in both editions?
Compact Edition, Mobile Edition, Or Something Else On CE 4.2?
Oct 5, 2007 I'm currently looking at adding a database to my company's WinCE 4.2 -based device, running applications coded with embedded CE 4.0. We want to start tracking potentially large quantities of user data (10K-30K 500 byte records) and are looking at a database engine to support this. The database would reside on the device although we would potentially dump the data from the devices to a central workstation that would be used to pull reports about the data across multiple devices. SQL Server Compact Edition sounds like a possible solution, but I'm unclear if it's supported on CE 4.2 or how to install it if it is. It's clearly supported on CE 5.0, but it may be a while before we upgrade to CE 5.0 or 6.0. I've seen references that say that SQL Server Compact Edition is the same as SQL Server Mobile Edition, and references that Mobile Edition is supported on CE 4.2, but I'm unclear if I can install and use SQL Server Compact Edition on CE 4.2 or if I'm on a wild goose chase. If not, can I use SQL Server Mobile Edition and migrate to SQL Server Compact Edition when we upgrade CE to 5.0 or 6.0? If not Mobile Edition, what about Microsoft SQL Server CE 2.0? Is that going too far back in the archives?
Thanks for any guidance/enlightenment you can offer.
Problem In Performance Monitoring...
Jul 23, 2003Hi
In performance monitor, Add Counters interface, it is pointed to the local SQL server as default.
Probably a kind of 'stu..' question. When I typied a remote sql server name in the "select counters from computer dropdown listbox", which is in my E.M. registered already, I got the error of "Unable To Connect To the Machine".
thanks
David
???Performance Monitoring Software???
Sep 22, 2005I am looking for a good solution for monitoring the performance on my SQL Server. I've used Performance Monitor but think there are better solutions out there. Specifically, I'd like to run the app on my desktop to monitor the server remotely. I'd like the app to run constantly and notify me if anything weird starts to happen.
I'm looking at i3 for SQL Server by Veritas as an option, but it's gonna cost ~$2k.
Anybody have comments, suggestions with the Veritas product or any other packages out there you would recommend.
Thanks,
Alex
Performance/monitoring Question...
Jul 6, 2007Running our software on many client sites.
Application:
1) using a 4gl language
2) uses ntwdblib.dll
Client MSSQL Servers:
1) varies from site to site on average dual core, 4GB, 20-100GB HD
2) MSSQL 2000 sp3-4, 2005 sp1-2
A handfull of our clients have complained about how slow things seem to be working. So after getting online with the customer and doing some investigating/testing, I have found that 'slow' is not the word to use. We are talking about snails pace. Now this same software at our other mssql sites doesnt seem to have any problems. very good performance numbers. Some of our customers with single cpu, 2GB, 10GB HD have better performance than a couple of our 4 cpu, 16GB, 2 - 20GB HD systems.
we have written a simple test program that we run on these slow sites that individually (useing local drives/files) are comparable to our faster sites. We then run the test program against the MSSQL database/tables. On the servers the run times are about the same. However, when we run it on a workstation the results go off the scale. At our good sites, the test time is around 10 minutes, on our bad sites the test time is around 1 HR 30 minutes.
Now i know this sounds like a network issue, but one of these slow sites had someone come out and check the network traffic/packets/routers/switches. then we paid to send that person to one of our faster sites to test their network. The results were that our slower client had a faster network. Our slower client uses CISCO smart switches/hubs/router.
Now for my question, does anyone know of or could recommend something that i could use to determine what is happening between the server and workstation on these slow sites.
Is there a problem with CISCO equipment and MSSQL 2005, NTWDBLIB.DLL. I am looking for anything here.
Performance Monitoring Suggestions
Jan 28, 2008We have a shared SQL 2005 instance and we have concerns about performance.
What tools would you suggest to monitor performance of a SQL server database? Would you use perf-mon? If so which monitors give you the best results?
Any help would be appreciated.
Thank you in advance.
Performance Monitoring A SQL 7 Cluster Configuration.
Apr 11, 2000I have SQL 7 running on an Active/Passive Cluster configuration. My problem is that I can not see any
SQL objects listed on perfmon.
Can this be because of the Cluster configuration? I trying to run perfmon directly from the main system console.
Thanks,
Randy
Performance Monitoring Tools For SQL Server
Aug 29, 2001Hi,
I'm looking for tool that will help me to monitor and analyze SQL server performance including SQL activities and server activities(cpu, memory usage) as well.
I appriciate any feedback,
Thank you,
Yelena
Favorite Monitoring (Performance) Tools?
Apr 25, 2007I'm fairly new to the DBA thing.
I've been doing quite a bit of research on monitoring MSSQL performance.
What tools are you guys using?
PerfMon, Dbartisan, Spotlight, or what?
I'd like to find some free or affordable way to watch our Servers to check health/performance/etc.
Monitoring SqlServer 2000 Performance With Express
Feb 18, 2007Hi,
I'm using Visual Web Developer Express and Management Studio Express, and my web site is on a shared web host´, running SqlServer2000. I'm looking for software that enables me to monitor the server, but is it possible? The only apps I've found (and downloaded and installed and unistalled) so far need administrative rights to the server so they won't work on a shared web host.
All help would be welcome!
Thanks in advance,
Pettrer
Performance Difference Between SQL Server 2005 Standard Edition And Enterprise Edition
Dec 15, 2006Dear All,We have a database which contains many tables which have millions ofrecords. When We attach the database with MS SQL Server 2005 StandardEdition Server and run some queries (having joins, filters etc.) thenthey take very long time to execute while when We execute same querieson Enterprise Edition then they run 10 times faster than on standardedition.Our database does not use any features which are present in EnterpriseEdition and not present in Standard Edition. We want to know what arethe differences between Standard Edition and Enterprise Edition forperformance. Why should we go for Enterprise Edition when StandardEdition has all the features required.We are presently using evaluation versions of SQL Server 2005 Standardand Enterprise Editions.Thanks and regards,Nishant Sainihttp://www.simplyjava.com
View 23 Replies View RelatedSMO And Compact Edition
Feb 12, 2007I am trying to make a simple example like sql management studio but stuck in the get table names part :) in first step. are there any easy way to get just table names from sdf file ?
I have tried to use SMO but no success.
Regards.
Store Procedure/scripts For Monitoring Replication Status And Performance
Jan 8, 2007Hi guys , may I know is there any examples of store procedure/scripts for monitoring replication status and performance ? I just know about sp_replmonitorhelppublisher. Thx for the assistance.
From,
Hans
ASP.NET And SQL Server Compact Edition
Sep 25, 2007I am writing an application that is designed for the desktop, or small group (3 or less) desktops. The application is being deployed using the Cassini web server as a complete "embedded" solution. I wanted to use SQL Server Compact because of its small footprint and because of the synchronization capabilities with SQLServer. Also, it is very easy to deploy vs. SQL Server Express. The idea behind this APP is that someone might use it locally and then decide to subscribe to the service and then connect the same application to a web services application.
That being said, and with knowledge of Microsoft's stance on SQL Compact under ASP.NET, I have most everything working and it works great except for one thing. When I add a SQLDataSource to the page and set the connection string to my file and the DataProvider to System.Data.SqlServerCe and then bind a data grid to the SQLDataSource, it runs fine on my development machine, but when I deploy to my clean test machine, I get an error when the page loads saying:
Unable to find the requested .Net Framework Data Provider. It may not be installed.
I can create a dataset in code (in fact,in several other places I do) and it works fine. It is just the SQLDataSource(s) that are throwing this error. I have a copy of System.Data.SqlServerCe.dll in the bin folder and I have all of the compact DLL's in the bin folder as well. I can't figure out what I need to do. I also have a reference to the System.Data.SqlServerCe in the web.config file.
Can anyone help?
SQL Compact Edition And SQLDataSource
Sep 26, 2007I am using SQL Server Compact Edition under ASP.NET. I am aware of the limitations and warnings from Microsoft for SSCE under ASP.NET, but this app is designed as a desktop deployed ASP.NET application running under the Cassini web browser. I wanted to use SQL Server Compact because of the RDA capabilities with SQL Server without the overhead of installing SQL Server Express. There would be 1-3 users at most running the application. SSCE seemed to make the most sense.
That being said, I have everything working fine except for this. I have added several SQLDataSource controls to several web forms and then I have GridViews bound to these controls. I like using the controls because of the built in sorting, grouping and updating I can do. When I run this on my development machine, it runs fine. When I move to one of my clean test machines and install the app, the SQLDataSouce controls throw the following error:
Unable to find the requested .Net Framework Data Provider. It may not be installed
I have the System.Data.SqlServerCe.dll in the bin folder along with all of the files from the the SQLServer Compact 3.1 install, a reference to it in the web.config file etc. In fact, I have several other database related datasets and tableadapters that are created throughout the application and they all work fine and can access and display data from my sdf file. It seems to only be with the SQLDataSource controls.
Any help would be greatly appreciated.
C# 2008 + SQL Compact Edition 3.5
Jun 4, 2008
I'm trying to start an application in C# with visual Studio 2008 and I want to connect it to a SQL CE 3.5 Database (local .sdf file).
I only found samples or How-to guides that use the wizard to add the datasource and the way dragging the dataset to the form. All things binded to the database where you don't have to do coding.
I don't want to have the binding navigator bar, I just want to use text box, date picker and buttons and Save that to the database myself. That way I think it will be more easy for me to validate or manipulate data before the insertion in the DB.
Some time ago a make an ASP.net that was doing same kind of thing with an Access DB...
Hope this can help to show what i really want...
(sorry for my bad english....)
Nick
Code Snippet
Private Sub btnAskSql_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAskSql.Click
lblMsg.Text = ""
Dim MyDS As New DataSet
'txtRequest.Text is a SQL command like Select * from.....
MyDS = SQLRequest(txtRequest.Text)
Try
DG01.DataSource = MyDS.Tables(0).DefaultView
DG01.DataKeyField = "ID"
DG01.DataBind()
Catch ex As Exception
lblMsg.Text = Err.Description
Finally
End Try
End Sub
Function SQLRequest(ByVal TheRequest As String) As DataSet
Dim _Con As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=" & Server.MapPath("Gifts.mdb") & ";")
Dim selectCMD As OleDbCommand = New OleDbCommand(TheRequest, _Con)
selectCMD.CommandTimeout = 30
Dim custDA As OleDbDataAdapter = New OleDbDataAdapter
custDA.SelectCommand = selectCMD
Dim TheDS1 As New DataSet
Try
custDA.Fill(TheDS1, "Request")
Catch ex As Exception
'oups
lblMsg.Text = Err.Description
Finally
_Con.Close()
End Try
Return TheDS1
End Function
Compact Edition 3.5 On A Network
Mar 18, 2008Hi all.
We are developing a desktop windows forms app that uses tha database as storage for application configuration.
It may be used by one user locally OR used locally by multiple but sharing the database.
Now, i'm really sure that I have read that sharing the .sdf file over a network is supported and thus have started developing against the 3.5 compact db (sdf file).
But when testing this scenario we get a message that sharing over network is not supported. I'm really surprised and frankly puzzled since I know I have read about this being supported.
So, can someone more into this subject exlpain to this to me? Is it supported, and if not, should we use the express version instead?
Also, if we have to change strategy, is there an easy migration path regarding development (app. is not even in beta stage so no migrations will be necessary with customers.).
Thankful for any help since this might cause a lot of extra work...
If this leads down the synchronization path, could someone please explain how this is set up. Is it one "master" that acts as a publisher?
If we would like to have the solution where several users access the same db-file (be it sdf or mdf), do we have any choice here?
/Regards
Sql Compact Edition And Methods
Feb 7, 2007i had read information about sce and i had not unsderstood a little thing:
is it possible or not to use a dataset with that version of sql server? i have a class that access the database with some functions and one of then return a dataset. the dataset is not to be used because it does not make sense with sql server compact edition or it cannot by use at all cause sql server compact edition does not support it?
thkx and by the way i think that it's a great product!
Compact Edition DVD Standalone
Nov 21, 2006Is it possible to run SQL Server Compact Edition as a standalone application from a DVD?
i.e. it would not leave anything installed on the users computer after the DVD was ejected.
SQL Compact Edition 3.5 Download URL?
Jul 24, 2007Dear all, Anybody knows where to download the beta release of SQL Compact Edition 3.5. Please provide the URL to download this 3.5 of SQL CE. Thanks Gops Sofist India gopalan@sofist.com
View 1 Replies View Related