billo
SSC-Addicted
Points: 467
More actions
May 2, 2012 at 6:03 am
#1482304
Also, no reporting services on this box but the reporting services that is on another box uses this server for its reporting services database. It is SSRS.
Ramukar LivingForSQLServer
SSCommitted
Points: 1749
May 2, 2012 at 6:04 am
#1482305
hi,
Pls have a look at Glen Berry's dmv collection (available in below link).
http://www.sqlservercentral.com/blogs/glennberry/2011/10/18/october-2011-sql-server-2008-diagnostic-information-queries/
both sys.dm_io_virtual_file_stats and sys.dm_db_index* dmv's helps to isolate db and object specific pains.
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply