SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• Extended Events shows each SQL command in one long line

  Hi all, I created Extended Events session to capture sql_batch_completed for duration>5 sec send…

  SQL Guy 1

  3 replies

  1 year, 9 months ago

  By: SQL Guy 1

• Extended Events to capture query causing tempdb log to get full

  Hi! How\Steps to setup Extended events to capture query causing tempdb log getting full? Can Query …

  PJ_SQL

  2 replies

  1 year, 9 months ago

  By: Grant Fritchey

• Query Store SQL 2016

  Hello! I am new to Query Store feature, once this is enabled it stores data captured in the databas…

  PJ_SQL

  5 replies

  1 year, 9 months ago

  By: PJ_SQL

• Single index reorg took 2 full days or more to complete

  I'm running an index maintenance job on 1 of my large database as the users recently perform massiv…

  JasonO

  3 replies

  1 year, 9 months ago

  By: Grant Fritchey

• Roles in cluster

  Hello! When we failover one node from another, does the roles from the node failover to another nod…

  PJ_SQL

  1 replies

  1 year, 10 months ago

  By: Jeff Moden

• Change the exsisting WSFC to a new WSFC in AG Configuration.

  Hi; We have a production SQL Server setup with AG configuration. The WSFC is not configured properl…

  vishwaa

  2 replies

  1 year, 10 months ago

  By: EdVassie

• Job History says running, but Job Activity says idle

  Hello experts, I'm hoping to get help with a strange issue. I got a request to stop a long-running …

  webrunner

  11 replies

  1 year, 10 months ago

  By: webrunner

• Server IP change

  We are planning to change the server IP of normal SQL Server instance, not a cluster. My understand…

  sqlguru

  7 replies

  1 year, 10 months ago

  By: Steve Jones - SSC Editor

• Change Data Capture

  We performed a drop on one of our CDC Tables when we should have performed a sp_cdc_disable_table .…

  ericwenger1

  1 replies

  1 year, 10 months ago

  By: ericwenger1

• Can log backups cause Operating system error 32?

  Hello experts, I am seeing sporadic (every other day or every few days) errors like this one for a …

  webrunner

  3 replies

  1 year, 10 months ago

  By: EdVassie

• SQL Agent Job Notification

  Hi - I have maintenance plan that rebuilds indexes nightly on a specific database. In its related S…

  SpartanDBA

  1 replies

  1 year, 10 months ago

  By: Ant-Green

• Question about Parent-Child table using CASCADE

  I used update cascade for connecting my parent with my child table, As my program requires my child…

  annie31

  2 replies

  1 year, 10 months ago

  By: Phil Parkin

• Eroor 823 SMB cluster

  Hello,   I'm in hectic problem-Heritage an SQL 2016 cluster with 2 VM's and SMB as shared file…

  aureliu

  2 replies

  1 year, 10 months ago

  By: cyrusbaratt

• Any way to store successful logins in a different event log?

  Hello experts, I am running into an issue where log information in the Windows Application event lo…

  webrunner

  5 replies

  1 year, 11 months ago

  By: EdVassie

• Database mail basic authentication / anonymous deprecated ?

  Hello to everyone. Anyone knows if the database mail feature (msdb.dbo.sp_send_dbmail) will be impa…

  luiz.carvalho

  4 replies

  1 year, 11 months ago

  By: luiz.carvalho