RayofCommand
  • Member for 7 years, 7 months
  • Last seen more than a week ago
SQL Server Rollback being performed - how to stop it?
Accepted answer
7 votes

@MaxVernon already gave all the info you need. Just some addition from my side. The bigger the transaction the harder the (pre)calculation for the SQL Server. That's why your remaining time in ...

View answer
Is there a Maintenance Plan that checks my database for corruption?
Accepted answer
5 votes

Good question. The integrity check in the maintenance plan is enough since it will run a dbcc checkdb. From MSDN: integrity check The Check Database Integrity task encapsulates the DBCC CHECKDB ...

View answer
Is it enough to have only full backup and transaction log backup only for a good backup plan?
3 votes

The use of the differential Backup is simple. Instead of restoring a huge amount of log backups in a row, you restore a full, a diff and a small amount of transaction log backups instead. Yes you ...

View answer
Large Transaction Backup
3 votes

You most probably re-index your database between the log backups. This means your log backup contains a lot of transactions from these maintenance operations. Please check your maintenance plans. The ...

View answer
SQL Server deprecated Functions effect
Accepted answer
3 votes

Deprecated functions / features work fine in your current SQL Server Version. It is just a hint for you that in future versions of the SQL Server these functions will be dissmissed or replaced by ...

View answer
Copy SQL DB files/backups
Accepted answer
3 votes

I can recommend to use Robocopy, it has the support of multi threaded copy. And it won't take ages to calculate the packages before. Your syntax would be as follows: robocopy "C:\SOURCE\Folder\...

View answer
Reclaim unused space
Accepted answer
2 votes

There is no other way than shrinking a db to claim back unused space. No matter if you truncate or delete data or update with smallers length of data, the .mdf file will stay the same size. Which is ...

View answer
SQL Server Estimated I/O Cost in real units
2 votes

I guess you are looking for a T-SQL command called "set statistics io on" USE YOUR_DB_NAME; GO SET STATISTICS IO ON; GO if put that before your query you will see the read pages the ...

View answer
SQL Server 2008 commit overhead warnings
Accepted answer
1 votes

Using performance monitor in windows you can for example watch the redo queue. Also any other db monitoring tool would help. The next sentence explains the redo queue, since I can't do it better than ...

View answer
High SOS_SCHEDULER_YIELD and Signal Waits
1 votes

First of all, signal wait time is the time a query is ready to run, but waiting for a CPU "slot" to be ready. When you are under CPU Pressure everything will be slowed down. To determine which query ...

View answer
What MAXDOP setting should be used for MS SQL Server 2012?
1 votes

Your error seems more related to memory pressure. Maxdop is a CPU setting. The Max degree of parallelism is heavily depending on your queries and your needs. You need to try it out. What should know ...

View answer
Query optimization and takes less execution time
0 votes

Please run SET STATISTICS IO ON and run one of your queries and check the number of pages beeing read in your message tab. A lower execution time doesn't mean that it was more efficient, there are ...

View answer
database with same schema and same AWS instance type, but different performance
0 votes

There are several things which are needed to know here. Some EC2 Instances on AWS are using shared CPU, this could be one reason why your instances are performing different. Also the same EC2 ...

View answer