Viewing 15 posts - 76 through 90 (of 245 total)
I would also use SP_WHO_ISACTIVE, to see what is currently using resources.
Always a good starting point.
June 22, 2017 at 2:13 am
Does the account that is running SQL SERVER SERVICES have permissions to the Windows file or folder.
June 20, 2017 at 8:45 am
Hi
In an ALWAYS -ON setup only user databases are synch'd across to the secondary or secondaries. The system databases are not shared in this environment. You have to think...
June 8, 2017 at 1:07 am
I use it everyday and just use the server name and not the listener name to register in CMS. As they are separate servers and need to be queried individually...
June 7, 2017 at 3:54 am
There is a link to MS in the link below.
June 2, 2017 at 3:37 am
I think I read a while back about instance stacking and the default port for the LISTENER, I'm sure best practise states that the default port for the Listener on...
June 2, 2017 at 3:24 am
Can you make sure the DNS name is being used for the LISTENER connection in the 1st Script.
select * from sys.availability_group_listeners
SELECT
AG.name AS [AvailabilityGroupName],
ISNULL(agstates.primary_replica, '') AS...
June 2, 2017 at 3:16 am
To be honest I haven't really read your post properly, but from scanning I think you maybe looking for this.
USE Master;
GO
CREATE TABLE [dbo].[#TmpErrorLog] (
May 30, 2017 at 3:17 am
May 17, 2017 at 3:23 am
I think you know what you have to do already.
Just TEST and make sure all is well.
May 15, 2017 at 4:40 am
Is the identity column and Identity (1,1) column if you script out the table.
I think TRUNCATE is your best option, but test first.
If you go to the...
May 15, 2017 at 4:20 am
Do you need to keep any of the data in these tables?
May 15, 2017 at 4:01 am
https://dba.stackexchange.com/questions/2247/how-to-set-full-text-catalog-location-sql-server-2008-2012
Found the above on Line
May 15, 2017 at 2:34 am
You need to run that script at the time the log is growing, or the process that is growing the log is running.
Hence logging it to a table, if...
May 11, 2017 at 3:02 am
May 11, 2017 at 2:59 am
Viewing 15 posts - 76 through 90 (of 245 total)