Viewing 15 posts - 1 through 15 (of 2,637 total)
I can't say this is anything I have ever noticed.
April 12, 2016 at 4:48 am
Hi Steve - thanks
just to clarify .. our current setup for all our applications which store state is to use a state database on the same cluster as the client...
April 12, 2016 at 4:35 am
You are making the same basic mistake everyone seems to with DR and HA .. yes multisite clustering is great .. but this has to mean you're using multiple storage...
April 5, 2016 at 9:49 am
I've a suggestion - set your checkpoint to a manual interval which isn't 4 mins - just to make absolutely sure.
April 5, 2016 at 8:36 am
No-one have their state database in the web tier or on a separate server then?
Am I unique in following this solution?
April 5, 2016 at 8:32 am
Log shipping is simple to maintain but does give you a read only database - this might not be what you intend.
Log shipping can deal with just about everything you...
April 5, 2016 at 8:31 am
If it works why make changes .. also nics belong to windows not sql .. I don't see why you would think network setup would change with a sql version....
April 2, 2016 at 6:11 am
sorry should have said only the dba team have sa rights and local admin to the dev sql boxes - the agent service runs as a domain service account which...
April 2, 2016 at 6:07 am
I have a whole multitude of automated jobs which do exactly as you state.
CREATE USER [MySQLUser] WITH DEFAULT_SCHEMA = dbo; -- SQL User
CREATE USER [ThisDomain\Developers] FOR LOGIN [ThisDomian\Developers]; -- AD...
April 2, 2016 at 6:03 am
I'm guessing that the start from date for your second job isn't 3 months to your required run date. Your schedule is set for every 3 months based upon...
April 2, 2016 at 5:52 am
I have to admit I have failover clusters and availability groups but not together.
I have heard that you can use a failover node as part of the availability group.
March 31, 2016 at 8:19 am
Much as I dislike generalised articles about setting up SQL Server, and I disagree with much of this article, it does provoke discussion and my fellow DBA and I had...
December 29, 2014 at 4:39 am
shows on my SSMS - sql 2008 running on w2012 cluster. I actually use SQL Diagnostic Manager for monitoring so this will alert me if the service is offline.
November 26, 2013 at 4:07 pm
It's all rather subjective and as usual just depends.
There are a number of problems concerning spikes and averages and the granularity you choose to plot your data will affect your...
November 26, 2013 at 4:01 pm
no worries .. trying to figure out poor performing SSRS seems to be a very black art!
October 28, 2013 at 3:57 pm