Viewing 15 posts - 91 through 105 (of 245 total)
Just to add it will tell you the SPID that is causing the issue.
You might want to log SYS.SYSPROCESSES to a table too, if you don't have a monitoring...
May 10, 2017 at 3:47 am
select * from sys.dm_db_task_space_usage
where internal_objects_alloc_page_count <> 0
Get this to table, you can see what has been using TEMPdb and the amount of pages allocated and deallocated.
May 10, 2017 at 3:43 am
Why not script out the database objects and all, users tables , sprocs, triggers etc.
Then use the Import data wizard to copy the data across. Why do you need...
May 10, 2017 at 3:24 am
This has always worked for me.
http://blogs.msdn.com/b/mattm/archive/2012/03/23/ssis-catalog-backup-and-restore.aspx
USE SSISDB
BACKUP MASTER KEY TO FILE = 'c:\DMK\SSISDB\key'
ENCRYPTION BY PASSWORD = 'OLDKEY'
-----------------------------------------------------
April 28, 2017 at 1:46 am
As a starter
SELECT TE.name AS [EventName] ,
T.DatabaseName ,
t.DatabaseID ,
t.NTDomainName ,
t.ApplicationName ,
t.LoginName ,
...
April 27, 2017 at 8:15 am
Not sure if I understand your setup but I have used FCI with AOAG. 2 FCI nodes for HA, 3 AOAG groops.
1 Primary( FCI for HA) x 2...
April 13, 2017 at 7:26 am
A full re-index rebuild will update stats. Is the DB being re-indexed every day?
April 11, 2017 at 8:50 am
select * from sys.dm_db_task_space_usage
where internal_objects_alloc_page_count <> 0
What has allocated pages in TEMPDB but not deallocated pages.
April 11, 2017 at 8:38 am
SELECT TE.name AS [EventName] ,
T.DatabaseName ,
t.DatabaseID ,
t.NTDomainName ,
t.ApplicationName ,
t.LoginName ,
t.SPID ,
...
April 11, 2017 at 8:36 am
Thanks for the replies. Most helpful. The server came back online and AOAG caught up.
I was going to ask how it did that when it was down for...
March 29, 2017 at 7:39 am
There are 3 nodes involved here,
1 Priamry
2 Secondaries
Only one of the secondaries is out of sync.
Removing the Secondarires from the AG...
March 28, 2017 at 5:07 am
Perry Can that be done on a per replica basis.
March 28, 2017 at 5:05 am
All dbs are out of SYNC is this the best way to do it. Rather than remove the dbs from the AG and resync all replicas.
March 28, 2017 at 3:43 am
Viewing 15 posts - 91 through 105 (of 245 total)