Viewing 15 posts - 46 through 60 (of 174 total)
This should help you - https://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/
May 16, 2017 at 8:33 am
Here's a handy script you could use which will generate Alter Authorization commands for the sa on the instance for you on all the databases in the instance if they...
May 11, 2017 at 12:18 pm
So only scenario where the failover occurs is when the whole server is down?
A: I wouldn't say only. You can always manually failover, but, for automatic failovers, it's...
May 10, 2017 at 7:34 am
Hi, Stopped SQL service from Configuration manager in a cluster, is the failover supposed to happen?
A: You should always use FCM (Failover Cluster Manager) to stop clustered services (roles). ...
May 9, 2017 at 7:18 am
"I've added tempdb datafiles (ndf), but never an addtional log (ldf). Did I miss something? Add a second log file if you are maxing out on space with the...
April 19, 2017 at 10:48 am
Hello Raymond, so, when you say "synched" do you mean after a failover the databases becoming available? Or, is there an additional HA option being performed, such as log shipping,...
April 6, 2017 at 6:52 am
I think I follow what you are asking for clarification on - The word "replica" has been made to be confusing. It technically means the Sql Server instance involved with an...
March 28, 2017 at 2:19 pm
It sounds like not enough permissions on the target database. What if you only give that account the db_datawriter role, does the insert succeed then?
February 9, 2017 at 8:55 am
Please see replies below -
Some of Indexes on table are 99% Fragmented.. is this a reason for me too worry about?
A matter of opinion, but, if the...
February 8, 2017 at 2:37 pm
See if this script will help you. To get the most recent backup, the msdb database is utilized -
-- This works really well on the source
January 18, 2017 at 11:11 am
The key is, while in Management Studio, ensure that the "Object Explorer Details" window is showing (if not, add it from the View menu), then you can select multiple jobs...
January 11, 2017 at 10:17 am
Hi Robin, it definitely sounds like there is much more space needed for the tempdb log file. Pre-sizing the log file is much better than allowing it to auto-grow....
January 6, 2017 at 1:11 pm
Is it possible that the log is indeed filled to 80% used at some point during the index maintenance? A transaction log backup would most likely decrease the size...
January 5, 2017 at 11:30 am
Can you post the sql (code) from the alert?
January 5, 2017 at 10:39 am
Check this link out from Brent Ozar, they just did a write up of exactly what you are asking - https://www.brentozar.com/archive/2016/12/install-multiple-instances-sql-server/
December 8, 2016 at 11:56 am
Viewing 15 posts - 46 through 60 (of 174 total)