Viewing 13 posts - 1 through 13 (of 13 total)
Thanks for the input. But since I posted this question six years ago, I don't have all the code instrumented and ready to test suggestions right now.
January 14, 2019 at 11:13 am
Thanks for the replies.
Both the query above from Chris and the queries in the thread to which Sue referred indicate that internal objects, user objects, and version store...
July 3, 2018 at 3:35 pm
jeff.mason (4/15/16)
https://msdn.microsoft.com/en-us/library/bb677167%28v=sql.120%29.aspx%5B/quote%5D
I was starting to get excited when I read this, because it almost exactly describes the problem I was facing...
Until I got to the part that says...
April 15, 2016 at 11:50 am
Have you identified the corruption? has the server team looked at the drives or SAN?
Both our internal SAN team, and the vendor have looked at it, and assured me that...
April 15, 2016 at 11:42 am
OK, think I understand (or at least have enough information to set up a rehearsal disaster recovery on our dev environment).
Thanks so much to everyone for their input.
April 13, 2016 at 9:22 am
they won't restore in a RECOVERING state so that you can then apply log backups.
That makes sense.
the biggest push against the SAN backups as the primary means of backing...
April 13, 2016 at 7:39 am
So, to kind of re-iterate a question from higher in the thread:
If I do just a log backup in a timed job, and then restore a "snapshot" of all the...
April 12, 2016 at 4:16 pm
run a disk subsystem diagnostic
Recommendation for a tool to use? Chkdsk shows no problems, and whatever tools the SAN guys used to check it showed no issues.
consider keeping an eye...
April 11, 2016 at 4:59 pm
Have you identified the corruption? has the server team looked at the drives or SAN?
Both our internal SAN team, and the vendor have looked at it, and assured me...
April 11, 2016 at 2:50 pm
Interesting stats. Our network admins have graphs that show the system pulling 12K read IOPS; the 1200 read IOPS was just what perfmon was saying at the moment.
But, whether 12...
March 11, 2016 at 12:17 pm
@alex Suprun
Nice script. Site needs a +1 option.
>What else do you want from memory?
Ultimately, I'd like to trim some of the read IOs if possible, since the SAN...
March 11, 2016 at 8:45 am
Buffer cache hit ratio is around 99%
Page life expectancy is over 2.8 million
Lazy writes/s is around 2-3 average, peaking around 50 occasionally
>Could just be over provisioned RAM, and you're only...
March 10, 2016 at 4:36 pm
Windows Server 2008R2
SQL Server 2008R2 SP1 (10.50.2817)
Thanks for the links. I had already read the first, and the second doesn't seem to apply to my OS.
>If you want to force...
March 10, 2016 at 3:43 pm
Viewing 13 posts - 1 through 13 (of 13 total)