Grant Fritchey

Forum Replies Created

Viewing 15 posts - 2,446 through 2,460 (of 22,219 total)

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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

July 30, 2019 at 10:51 am

#3667145
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

July 29, 2019 at 1:51 pm

#3666832
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

July 29, 2019 at 1:31 pm

#3666826
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

July 29, 2019 at 12:59 pm

#3666782
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

July 29, 2019 at 12:55 pm

#3666778
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 29, 2019 at 12:52 pm

#3666776
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

July 29, 2019 at 12:49 pm

#3666773
Reply To: Restore Databse From SQL Server 2014 to 2016 Database Size was Increse

Did the recovery model get changed and the logs are now huge?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

July 29, 2019 at 12:15 pm

#3666757
Reply To: Simple Select * very slow

Just piling on here.
When comparing the performance between two systems, we have to know that every possible thing is identical before we can say "See, SystemA is sucky and SystemB...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

July 29, 2019 at 12:11 pm

#3666755
Reply To: SQL Server manually forced plan is unforced ?

Yes. If anything has changed in the structures such that the forced plan is no longer valid, it'll just get ignored.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

July 29, 2019 at 12:07 pm

#3666754
Reply To: Take backup without transactions

I strongly recommend just focusing on the point in time recovery as your mechanism. It's easy to set up. Completely supported in every way. You won't have to do anything...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

July 29, 2019 at 11:19 am

#3666742
Reply To: Take backup without transactions

Jeff Moden wrote:
Grant Fritchey wrote:
Restore to a point in time. That's all you have to do.
Now THERE's an idea!!! That's why they pay you the big bucks!
Whoa! Hold on a sec....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

July 26, 2019 at 6:48 pm

#3666439
Reply To: Take backup without transactions

Restore to a point in time. That's all you have to do.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

July 26, 2019 at 6:43 pm

#3666435
Reply To: Take backup without transactions

You can't take a full backup without transactions. It's fundamental to the recovery aspect so that it can successfully restore without corrupting the database. Not only do can you not...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

July 26, 2019 at 12:24 pm

#3666305
Reply To: Are the posted questions getting worse?

Luis Cazares wrote:
Jeff Moden wrote:
Luis Cazares wrote:
Lynn Pettis wrote:
Grant Fritchey wrote:
You're all still here? Go home. (btw, hate that movie, but it's a good quote)
I enjoyed the movie. Too bad you hated it.
...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

July 23, 2019 at 1:39 am

#3665258

Viewing 15 posts - 2,446 through 2,460 (of 22,219 total)