iwatson

Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)

Reply To: Simple Select * very slow

i think i might have found something:
PAGEIOLATCH:
slow instace/db = waitcount 1620
waittime ms 282476
fast instance/db = waitcount 257
waittime ms 85164

July 30, 2019 at 8:22 am

#3667106
Reply To: Simple Select * very slow

tripleAxe wrote:
where are you running the select from?
management studio

July 29, 2019 at 1:33 pm

#3666828
Reply To: Simple Select * very slow

Management Studio

July 29, 2019 at 1:33 pm

#3666827
Reply To: Simple Select * very slow

yes took a backup and restored on the slow instance still slow

July 29, 2019 at 1:28 pm

#3666819
Reply To: Simple Select * very slow

yes its fast if i restore it on the fast instance

July 29, 2019 at 1:26 pm

#3666817
Reply To: Simple Select * very slow

July 29, 2019 at 1:25 pm

#3666816
Reply To: Simple Select * very slow

Hi Andrey yes been doing that and clearing cache
DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS
before each query.

the annoying thing is the contoso DB's are fast on both instances...

July 29, 2019 at 1:08 pm

#3666808
Reply To: Simple Select * very slow

Hi Andrey, yes same database and tables download from MS website.
small or large tables perform almost identical on Contoso

July 29, 2019 at 12:56 pm

#3666779
Reply To: Simple Select * very slow

thanks even though the contoso DB on both instances select query is fast on both instances?

July 29, 2019 at 12:51 pm

#3666775
Reply To: Simple Select * very slow

thats the point though, its 2 instances on the same server, so hardware and load is the same...

migrated the live DB off so the load is minimal

July 29, 2019 at 12:44 pm

#3666771

Viewing 10 posts - 1 through 10 (of 10 total)