<div>
<div class="content wysiwyg-content">
I am having performance problems with a Pervasive SQL database running on Windows 2008 server. I learned earlier on EE that no SNMP monitoring is available for PSQL. But I suspect that the slowness problems I am seeing with PSQL are related to ODBC and/or ADO.NET connections querying this server. Is there a means of monitoring the ODBC connection requests or other aspect of the ODBC connections on the target server? SNMP? WMI??
</div>
</div>


I am having performance problems with a Pervasive SQL database running on Windows 2008 server. I learned earlier on EE that no SNMP monitoring is available for PSQL. But I suspect that the slowness problems I am seeing with PSQL are related to ODBC and/or ADO.NET connections querying this server. Is there a means of monitoring the ODBC connection requests or other aspect of the ODBC connections on the target server? SNMP? WMI??

How to Monitor ODBC connections and ADO connections on a Windows server?

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

Network analysis is the process of identifying and remediating the processes and systems within a network, including performance, connectivity and security. The process is performed through the use of tools developed for monitoring and analyzing network activity. Network problems that involve finding an optimal way of doing something are studied under the name combinatorial optimization. Examples include network flow, shortest path problem, transport problem, transshipment problem, location problem, matching problem, assignment problem, packing problem, routing problem, Critical Path Analysis and PERT (Program Evaluation & Review Technique).

Network Analysis

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.