How much RAM does the server have?
Hi, I have a problem with one server and the default data collection job failing. If someone could help that would be great!...
Hi, see the attached image. I don't think it's permissions or protocal related as it will just randomly fail once every couple of days. and no not...
Hi i have a strange issue, i have setup the inbuilt data collection jobs on one of my SQL 2008 R2 servers. it's writing back to another SQL server. i...
24 physical cores, thanks.
Hi, i have a 2 node cluster running on windows 2008 R2 with SQL 2008 R2. I am wanting to resize my Tempdb size from 10gb to 2gb and split it into 6...
Hi, just setting up a new SQL 2008 R2 box on server 2008 R2. I've never used Raid 50 before and was wanting some feedback on it's performance...
Basically i am wanting a better understanding of what happens in server 2008 R2 when you put a disk in maint mode. In R2 does it still take the...
Hi guys, just need to clarify something. does maintenance mode take the disk offline, i did a Windows Server 2008 course where the course material...
i already have data collection warehouse running thanks Satya. btw what counters should i look at to indicate tempdb is a problem when i look at the...
Yep it's physical not vm. so 6 files would be a good start? so will SQL deal ok with turning my 10gb single file into say 6x2048mb files?
it's 4 cpu with 6 cores per cpu. all physical cores. 32gb of ram.
What would be the recommended starting point for splitting tempdb on a server with 24 physical cores? would 6 be enough to see an improvment if we...
Hope this is what you are looking for. Message Executed as user: . ...update is not necessary... [SQLSTATE 01000] (Message 15653) , update is not...
USE [MOSAIQ] EXEC sp_updatestats GO That query is run as an agent job every night if that helps.
Actually the reports are the only thing thats improved. since though i have setup a restore job on another server and have pointed all our reports to...
Hi guys first time poster. We have recently upgraded our application (medical application) from a pervasive SQL backend to a MS SQL backend. Since we...
Separate names with a comma.
