SQL Server Profiler trace different result on different system for same query
I run same JAVA application (spring/hibernate) on different system both use same SQL Server version.
I'm using SQL Server Profiler to trace a query which I run (exactly same) on both systems.
This is my SQL Server version on both system:
Trace System 1 : slow-system2.trc query takes randomly between 100 - 300ms
Trace System 2 : fast.trc query takes randomly between 10-20ms
It seems here on slow-screenshot a query of "use database" takes "331ms" compared to fast.trc (0ms= :
What can cause this difference just by running "use database" query ?
I tried on a 3th system running on sql express which is too slow here is trace
It seems here on "sql express" it is due to the fact I have two additional classEvent Audit Logout that takes time :
Maybe I missed out some option on SQL Server?
The long duration of the USE statement indicates the database may be set to AUTO_CLOSE ON. Overhead is incurred during database startup when it must be opened.
The setting can be changed with:
ALTER DATABASE [YourDatabase] SET AUTO_CLOSE OFF;
- opposite of "top" in sql server, without using order by, there are no keys/indices
- Getting log messages from an SSIS package executed with an SQL query
- Project fails to load due to missing SqlServer.targets file after upgrading to Visual Studio 2013
- How to remove a specific character from a string, only when it is the first or last character in the string.
- convert datetime to bigint
- How to fix the "system cannot find the file specified" error in ASP.NET MVC and SQL Server 2019
- How to get all auto generated foreign key names?
- Untrusted Certificate Error when connecting to SQL Server running in Docker from .NET 7 API in VS2022
- In a junction table, should I use a Primary key and a unique constraint, or a compound/composite key?
- Convert to ASCII char in SQL Server
- SQL transaction locks query weird behavior
- Update SQL with consecutive numbering
- Returning Continuous Months and Copying Values from the Previous Month
- Export stored procedure results as CSV (UTF 8 BOM format) to external server from SQL Server 2012
- SQL Server XML Data - How to insert if empty or update if not
- "Incorrect syntax near ')'." from cmd.ExecuteNonQuery();
- SQL Server - get next Friday in DATETIME
- Prevent Role with limited SELECT access discovering object names in Azure SQL or SQL Server
- What is the best way to create and populate a numbers table?
- How to preserve data comma ',' while exporting data from SQL Server to flat file (CSV) where column delimiter is ','
- SQL Selecting if "active" = true
- Delete partial dulicate rows - sql
- How to disable transactions for individual migrations in Flyway on SQL Server
- Why does a WHERE IN query on a uniqueidentifer column result in a "range seek" (greater than/less than)?
- Stored procedure to insert a new employee and return the newly created record (including the Id)
- Generating a histogram from column values in a database
- Get size of all tables in database
- How can I get the size in bytes of a table returned by a SQL query?
- Reading a table from SQL Server into a DataFrame using SQLAlchemy
- QSqlQuery causing ODBC Function sequence error