Viewing 15 posts - 16 through 30 (of 1,179 total)
If you are not sure about t-log you can also take differential bakcup and subsequent t-log backup and restore on the database.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 26, 2015 at 8:08 am
Also check if any open transactions are running when tempdb is growing. Also check if data or log files are growing to narrowdown the issue.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 26, 2015 at 8:00 am
What SQL Server version you are using? Check the feature "Always On" of SQL Server 2012 if using SQL 2012.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 26, 2015 at 7:47 am
You can also do the same by exeucting Restore backup job. After that recover database.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 26, 2015 at 7:42 am
Compare to Mirroring, always on will have more flexibility. I would prefer always on. e.g. multiple database, multiple secondary and much more.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 26, 2015 at 7:39 am
Are you facing any resource issue? provide more detail.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 26, 2015 at 7:28 am
Yes, it is always better to have seperate database which will result into easy maintenance of the database and easy to narrow down the issue you will have on specific...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 25, 2015 at 8:20 am
check following link:
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 25, 2015 at 8:11 am
What is the analysis of your storage Admin? Usually read should not be high? Does it happen on all server using same SAN? If it is new server with no...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 25, 2015 at 7:11 am
Agreed with Grant.
Refer following article to do further R&D.
http://blogs.msdn.com/b/psssql/archive/2015/03/06/does-rebuild-index-update-statistics.aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 25, 2015 at 6:59 am
Were you able to connect earlier? Looks like DNS issue and work with network team to resolve the issue.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 25, 2015 at 6:53 am
Check the following link which might help you. You can modify the same as per your requirement.
http://www.keepitsimpleandfast.com/2009/09/use-batches-to-delete-large-number-of.html
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 25, 2015 at 6:42 am
This is very broad sense. What exactly you would like to compare?
To start with comparing the output of two server in xls. You can execute sp_configure to get the detail...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 25, 2015 at 6:37 am
Easy one, Thanks.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 25, 2015 at 6:29 am
Make a simple test. Take stored procedure which is running slow after reboot of the server (or RESTORE) and execute quickly from the second execution onwards.
Simply recompile that stored procedure...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 24, 2015 at 8:34 am
Viewing 15 posts - 16 through 30 (of 1,179 total)