SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• AlwaysOn Q: Read-only replicas for 2 different AGs in the same instance?

  Hi, Does any know is it possible to have read-only secondary databases from 2 different AG groups o…

  Harvy

  2 replies

  6 years ago

  By: onetsql

• Issues using sys.dm_io_virtual_file_stats dmv to check CheckDB Reads

  I'm trying to get a picture of what impact our overnight CheckDB's are having on storage using sys.…

  onetsql

  4 replies

  6 years ago

  By: onetsql

• SQL Server Always on backup setup transaction log on Secondary

  Hello, hopefully a simple question and easy thing to implement... so i have an 2 node always on, Se…

  Siten0308

  2 replies

  6 years ago

  By: Nice Marmot

• Log shipping from sql 2008 to 2016?

  Hello, We want to do a migration, these databases range from 100-500 gigs of data, and want to log …

  Siten0308

  10 replies

  6 years ago

  By: Kevin3NF

• Check DB is failing

  one of the job is getting failing with the Command: DBCC CHECKDB TPX WITH NO_INFOMSGS, ALL_ERRORMSG…

  ramyours2003

  1 replies

  6 years ago

  By: Grant Fritchey

• Sort is taking time in execution plan

  Hi, I have a strange situation where SORT operator is taking 10 sec in prod database and when run t…

  IMary

  13 replies

  6 years ago

  By: IMary

• power shell script for add datetime to file

  Hi, i would like to generate csv file with datetime  through sql job with below power shell script.…

  adisql

  9 replies

  6 years ago

  By: Steve Jones - SSC Editor

• DR test issue

  Hi I have a DR test server that failed this morning due to lack of disk space. I've fixed most of i…

  MVDBA (Mike Vessey)

  1 replies

  6 years ago

  By: muthukkumaran Kaliyamoorthy

• Sql Server 2016 Service Pack 2 install hangs

  We have a SQL 2016 server with SP1 CU2 (13.0.4422.0). When I run theinstall for Service Pack 2, the…

  wayne.l.dueck

  12 replies

  6 years ago

  By: bhanumurthy

• Extended events - session not capturing information

  CREATE EVENT SESSION [AL_Alter] ON SERVER ADD EVENT sqlserver.sql_statement_completed(SET collect_…

  mtz676

  9 replies

  6 years ago

  By: Jacob Wilkins

• Restoring unencryped database into an encrypted database

  Hi I'm migrating databases from server that does not have TDE enabled, to another server that will …

  alex.palmer

  2 replies

  6 years ago

  By: alex.palmer

• When AG Failovers , what happens to open txns ?

  Hi All, Need help in understanding the behavior when AG fails over to other nodes. Assume that 10 S…

  vsamantha35

  1 replies

  6 years ago

  By: Eddie Wuerch

• sysprocesses showing blanks for hostname and programname fields. why?

  Hi All, For some of spids, I am seeing hostname and program_name as blanks. But, I am seeing sql te…

  vsamantha35

  1 replies

  6 years ago

  By: vsamantha35

• SQL server tempdb

  Hello, I currently right now have a tempdb that has grown but now with making some modifications an…

  Siten0308

  5 replies

  6 years ago

  By: muthukkumaran Kaliyamoorthy

• Sql server 2016 - Always ON installation on Windows Fail Over Clustering

  Hello, We have currently SQL Server 2016 (SP2-CU6)  (X64)   Standard Edition (64-bit) on Windows Se…

  pdsqsql

  2 replies

  6 years ago

  By: pdsqsql