Viewing 15 posts - 4,246 through 4,260 (of 49,571 total)
Means your IO subsystem will be getting driven very hard, high utilisation, and probably slow queries as a result. As I mentioned, I've seen a server where the PLE never...
November 18, 2015 at 7:08 am
Having multiple files on the same drive will alleviate PageLatch waits on the allocation structures in TempDB. That's why it's recommended. It will NOT help with PageIOLatch waits, as those...
November 18, 2015 at 6:13 am
Brandie Tarvin (11/18/2015)
GilaMonster (11/18/2015)
Brandie Tarvin (11/18/2015)
tripleAxe (11/18/2015)
Striping the backup to multiple backup files can help you reduce the backup/restore time.
In my experience, I have seen no difference between restoring...
November 18, 2015 at 5:45 am
Brandie Tarvin (11/18/2015)
tripleAxe (11/18/2015)
Striping the backup to multiple backup files can help you reduce the backup/restore time.
In my experience, I have seen no difference between restoring striped files and...
November 18, 2015 at 5:02 am
The syntax for adding a default to an existing column is a little weird
ALTER TABLE Projects
ADD DEFAULT SYSTEM_USER FOR create_user
November 18, 2015 at 5:00 am
Define 'not working'.
A backup from 2005 can be restored to 2008 R2 without any problems, so there's possibly something wrong with your backup file, or syntax.
November 18, 2015 at 12:17 am
My laptop's got more than that...
Seriously though, read the two chapters of the book that I recommended. Problems are not identified with a single counter value or setting.
November 17, 2015 at 10:35 am
Let me say this first. I have never heard of a case where a drive crashed, the mdf and ldf were recovered from the damaged drive and worked. Usually it's...
November 17, 2015 at 10:33 am
Sure it can. I've seen servers where PLE never made it above 5. Performance sucked, IO subsystem was maxed out, but SQL's not going to crash just because it's reading...
November 17, 2015 at 8:57 am
The question you probably need to be asking, is what was running that would cause the PLE to go to 0. If you can answer that (and it'll probably need...
November 17, 2015 at 8:46 am
Honestly, much the same way you do the backups, a script to run checkDB and the windows scheduler.
November 17, 2015 at 8:30 am
Just adding data files is not going to fix PageIOLatch waits, unless the files are spread across multiple independent drives/IO channels.
November 17, 2015 at 8:25 am
Bouke Bruinsma (11/17/2015)
There is a void statistic on t1 with norecompute to prevent recompilations. It cannot be stale by design.
And that, right there, is the cause. Useless statistics resulting...
November 17, 2015 at 8:23 am
Brandie Tarvin (11/17/2015)
GilaMonster (11/17/2015)
November 17, 2015 at 6:31 am
The heatwave here has just broken, yesterday was the first rain for almost a month and a half (in our peak rainfall season). It's been seriously unpleasant here since early...
November 17, 2015 at 5:49 am
Viewing 15 posts - 4,246 through 4,260 (of 49,571 total)