Viewing 15 posts - 31 through 45 (of 220 total)
Hi Chris, doesn't a high volume of adhoc queries with high compilations with batch requests cause CPU issues?
November 16, 2016 at 11:54 am
donstarter (9/5/2016)
That was the problem. I have installed CU1 and copied the file again. Works like a charm.Thanks for your help!
No problem, glad to have helped
September 6, 2016 at 1:52 am
Yes it worked for me, are you also on CU1?
September 5, 2016 at 7:46 am
donstarter (9/5/2016)
September 5, 2016 at 6:11 am
Perry Whittle (9/5/2016)
bugg (9/5/2016)
Thanks guys, due to my limited disk setup I have had to lump TempDB with user DB log files on a SSD.
Be aware this is not...
September 5, 2016 at 4:32 am
GilaMonster (9/5/2016)
I do not like in-place upgrades for production servers. If anything goes wrong in the upgrade (and I've seen it happen), then you're left with a non-working system.
Thanks, will...
September 5, 2016 at 4:26 am
Perry Whittle (9/5/2016)
GilaMonster (9/5/2016)
TempDB however may well need its own drive or two, depending how much load is put onto it.Exactly what I've been saying
Thanks guys, due to my limited...
September 5, 2016 at 4:17 am
Perry Whittle (8/31/2016)
master, msdb and model should just be left as is, no need to separate them.
Thanks Perry I have kept them together.
September 5, 2016 at 4:06 am
Perry Whittle (8/31/2016)
August 31, 2016 at 12:49 pm
bugg (8/25/2016)
I've decided to go LOG files with Backups as the backups are easy to move if i spot any contention/issues.
Any ones thoughts on this? Also I've been thinking...
August 29, 2016 at 2:29 am
I've decided to go LOG files with Backups as the backups are easy to move if i spot any contention/issues.
August 25, 2016 at 3:09 am
How about installing SQL Server on the same RAID subset as the OS?
This frees up RAID 1 disks for the LOG files.
August 25, 2016 at 1:39 am
Anyone have any suggestions, if I keep TempDb on its own RAID 1 array where would the best place be for the log?
Thanks B
August 24, 2016 at 7:40 am
Thanks Perry, if i keep Temp DB by itself on a SSD RAID 1
That leaves me a few options:
1) LOG file with DATA on RAID 10
2) LOG file with BACKUPS...
August 23, 2016 at 6:11 am
GilaMonster (8/19/2016)
August 23, 2016 at 2:39 am
Viewing 15 posts - 31 through 45 (of 220 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy