Viewing 15 posts - 1 through 15 (of 68 total)
Yes, it's a 3 node WSFC.
Only Svr1 and Svr2 are used for the SQL cluster (active / passive). We need to be able to fail back and...
November 18, 2016 at 10:10 am
Bad form replying to my own posts but for anyone else stuck as I was with "job cannot be found" when clearly the job does exist and you've been checking...
October 15, 2009 at 8:19 am
George Parker-378530 (10/14/2009)
exec linkedserver.msdb.dbo.sp_start_job 'job_name'
Yes I thought that might work too. Sadly I haven't (yet) been able to get it to work - it's always complaining about "Job1" does...
October 15, 2009 at 4:20 am
Logins / sec = ~4-500 :blink:
Logouts / sec = 20
User connections climb until they hit some sort of ceiling around 1400 and everything grinds to a halt. Hmmm.
September 9, 2009 at 7:42 am
The application team say yes, they do use pooling.
I don't know if it creates new connections for each data request or reuses them in the code but something...
September 9, 2009 at 4:16 am
Heh, I was just reading up on that, wasn't even aware of the option. Always something new to learn...
In answer, no.
I'm wondering about a change of tactics: Create a...
August 13, 2009 at 5:07 am
I don't control the backups to tape and they are set to backup all including the SQL databases. :ermm:
August 13, 2009 at 4:50 am
Trying pinging the other server - login timeout expired suggests to me that the DNS name isn't resolving.
Or
If you've got these express instances on Windows XP workstations that the Windows...
August 12, 2009 at 9:58 am
If everyone connects to the dbs via EM then the answer is no.
I'll assume that you've found yourself in a similar position to most companies: every man and his dog...
August 12, 2009 at 8:43 am
Are you needing the physical disk slots in the current server to upgrade the disk capacity for D? Ie, you have 5 physical slots with say 18Gb disks in...
August 12, 2009 at 8:11 am
Firstly a thanks to you all for your suggestions and pointers. 🙂
I've been studying the DMV stats and tracking through the excellent MS documents on this topic (trying to jam...
July 7, 2009 at 8:34 am
It seems to be that as soon as the number of connected users jumps up beyond a certain level the machine sags to its knees. Having said that, the...
July 6, 2009 at 10:42 am
Yes I'm sure it's SQL taking all the CPU.
It's not the disks, least not what I can see from the metrics. Disk Q and Disk Busy % are all...
July 3, 2009 at 9:41 am
You could use command shell (but it's hideous) so I'd suggest a Windows scheduled task running either vb script or DOS batch file.
July 2, 2009 at 10:40 am
Many thanks for your comments, it confirms many of my suspicions about this box which isn't very well :sick:
It's not a reporting system and I have a feeling there's been...
June 30, 2009 at 10:08 am
Viewing 15 posts - 1 through 15 (of 68 total)