muthukkumaran Kaliyamoorthy

Forum Replies Created

Viewing 15 posts - 76 through 90 (of 859 total)

RE: Availability group listener is not listening

Hamid-Sadeghian - Monday, January 7, 2019 12:37 AM
I've successfully created an availability group with 2 nodes that one node is physical and...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

January 7, 2019 at 12:47 am

#2018115
RE: Update stats

Change the job timing, where you have low activity.
Enable trace flag 1222,-1 to gather information in the log to review later.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

January 6, 2019 at 12:14 am

#2018082
RE: SQL AG Upgrade

sdavis754 - Sunday, December 30, 2018 7:10 AM
Hi,
I am looking for an advice.I am planning an AG upgrades to 2017.I read in...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

December 30, 2018 at 10:30 pm

#2017626
RE: Learning DBA

sizal0234 - Saturday, December 29, 2018 10:58 AM
In addition to automation do you recommend any books or strategy which helps in moving...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

December 30, 2018 at 10:26 pm

#2017625
RE: impact delete AVAILABILITY GROUP

abdalah.mehdoini - Wednesday, December 26, 2018 1:20 AM
Hello everyone
if I proceed to eliminate the Group avaibility through
DROP AVAILABILITY GROUP...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

December 26, 2018 at 4:25 am

#2017313
RE: Migrating DBs to another server

Michael L John - Wednesday, December 19, 2018 10:03 AM
Instead of re-inventing the wheel, take a look at these tools:
https://dbatools.io/commands/
I...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

December 21, 2018 at 2:30 am

#2017027
RE: Availability Group Database - Resize of LOG file causes Transaction Log use to grow significantly

tking 39890 - Thursday, December 20, 2018 4:44 AM
Tom - Yes, I have tried to run that query and see nothing listed. ...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

December 20, 2018 at 4:52 am

#2016930
RE: Migrating DBs to another server

You can write a dynamic SQL script for both backup and restore by using a system tables.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

December 19, 2018 at 7:16 am

#2016818
RE: SQL Server : Parallelism vaules best practice

santosh.mane - Wednesday, December 19, 2018 5:21 AM
Hi,
We are using SQL Server 2012 having Always on High Availability setup ( Active -...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

December 19, 2018 at 7:14 am

#2016817
RE: SQL Crash "The transaction log for database 'master' is full due to 'CHECKPOINT'"

kvacola - Tuesday, December 18, 2018 6:07 PM
SQL 2008 instance was running on a VM. It ran out of space so IT...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

December 19, 2018 at 2:05 am

#2016796
RE: problem with restore a backup in sql 2000. help me

almirfiorio - Friday, December 14, 2018 12:10 PM
John Mitchell-245523 - Friday, December 14, 2018 9:41 AM
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

December 17, 2018 at 2:19 am

#2016461
RE: When Statistics Update

Thanks for the question Kendra.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

December 14, 2018 at 12:51 am

#2016285
RE: Can it be improved again?

In the plan 50+ percentage of cost going to key lookup for the table - [s_stkdetl]. You have to review the existing index and need to create a non clustered index...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

December 13, 2018 at 10:21 pm

#2016279
RE: DB Integrity job failed (using Ola hallengren's script)

https://stackoverflow.com/questions/52281868/variable-for-sqllogdir-not-found
Check this as well.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

December 12, 2018 at 7:55 am

#2016099
RE: DB Integrity job failed (using Ola hallengren's script)

Administering Databases - Monday, December 10, 2018 6:32 AM
I am using Ola Hallengren's script for DB integrity so I tested the script...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

December 12, 2018 at 7:46 am

#2016097

Viewing 15 posts - 76 through 90 (of 859 total)