Post reply

Colocated databases

  • May 21, 2022 at 8:03 am

    #4036626

    Hi All,

    How to tell or prove if colocated databases / database files in same disk / drive is having a performance problem.

    Sometimes, I see errorlog entries I/O requests taking more 15 secs warnings.

    Thanks,

    Bob

  • May 22, 2022 at 8:10 am

    #4037048

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • May 24, 2022 at 7:15 am

    #4038039

    In general, I am checking 2 or more databases are placed in the same drive then would it cause any issue.

    How can I leverage the sys.dm_io_virtual_file_stats to determine is there any IO perf problem?

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

You must be logged in to reply to this topic. Login to reply