Forum Replies Created
Viewing 15 posts - 2,446 through 2,460 (of 22,227 total)
-
Reply To: Performance problems with UI
Trace can do pretty much all you're looking for. It's just going to put a much heavier load on the system while it collects the data. Also, it's horrific at...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Are the posted questions getting worse?
You're going to blow it out of the park Brandie. Relax and have fun with it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Simple Select * very slow
BoobyB wrote:Please try running update stats on the table with the recompile option on the slow DB and run the query again.
Sorry, I'm confused. "update stats on the table with...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Performance problems with UI
Time to employ extended events and capture the query metrics. That's the single best thing you can do. Identify how long each query takes, how frequently they are called,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: OS Memory high
The same as with any performance problem, you have to gather metrics to identify where the issues lie. I can't tell you what the problem is because other than high...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Where Clause in T-SQL
That looks OK to me. Does it work?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: red cross in my server SQL
Check your databases. Sounds like one is corrupted. Run DBCC CHECKBD on them (during off hours, this is a fairly intensive query).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: From SQL2014 to Azure - courses / links?
First thing I'd do is understand if you're doing a lift & shift and just moving to Azure VMs, or, if you're implementing Azure SQL Databases or Azure Managed Instances....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Simple Select * very slow
That suggests a strong and distinct difference in I/O behavior. Are the different databases on the different instances on different disks?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Simple Select * very slow
Please, capture the wait statistics for the query on both fast and slow instances. Just running SELECT * over and over isn't going to tell us much unless we gather...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Simple Select * very slow
iwatson wrote:
So, the differences in index size and free space there suggests that the two databases are not identical. Was an index rebuild run on one of...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Simple Select * very slow
iwatson wrote:small or large tables perform almost identical on Contoso
Ah, but "almost" is not identical. If everything is equal, performance should be identical (within a small margin of error, again,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Simple Select * very slow
Identical database. Check?
Identical query. Check?
If either of those is wrong, one database is older than another or something, statistics updates were run, whatever, then everything changes. However, assuming identical databases...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Restore Databse From SQL Server 2014 to 2016 Database Size was Increse
Andrey wrote:tamil.selvanmca wrote:But in SQL server 2014 I am not use compression
I bet it's configured there by default
run the query on both servers :
SELECT *
FROM sys.configurations
WHERE..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Simple Select * very slow
The thing is, SELECT * from a table without a where clause is just a test of server settings, database settings, load, contention, and hardware. It's not anything else. There's...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 2,446 through 2,460 (of 22,227 total)