Viewing 15 posts - 30,811 through 30,825 (of 49,552 total)
SwayneBell (9/9/2010)
Houston, we have a problem. The person that told me this is responsible for our backups.I'll follow up - much appreciated Gail.
Ooops... 😀
Hey, look on the bright side. You...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2010 at 8:28 am
ALZDBA (9/9/2010)
Or maybe even contact Allen White via LinkedIn.
Or just think about him really hard and he'll appear. 😀
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2010 at 8:19 am
SwayneBell (9/9/2010)
I spoke with someone who (hopefully) knows this here and I'm told that our version of DPM (2007) does do the log backups.
Double-check by reading the SQL error logs....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2010 at 8:10 am
Not via F1. I usually just open the appropriate one from the start menu, then use the index to find whatever I'm looking for.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2010 at 8:08 am
Last I heard (may be a version or two ago though), DPM doesn't do log backups.
Check in the SQL error log. If it is doing a log backup, SQL will...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2010 at 6:35 am
sysdatabases is deprecated, should not be used for new development and will be removed in a future version of SQL Server.
SELECT name, recovery_model_desc from sys.databases
As for log backups, they're in...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2010 at 6:05 am
pankaj.kuchaliya (9/9/2010)
then it will increase the performance.
Maybe. Providing that the bottleneck is IO. It's not guaranteed to improve performance. If the cause of the poor performance is something other...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2010 at 5:50 am
pankaj.kuchaliya (9/9/2010)
How can i create file group on different physical drive.
The same way you create a file any other time. Just as a location put the other drive's drive letter...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2010 at 5:38 am
T-SQL runs synchronously. If you issue a BACKUP DATABASE, the code waits until the backup has finished, then goes on. The backups don't run in parallel.
Run the code in management...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2010 at 5:32 am
BaddaBing (9/9/2010)
You could also create a workload trace file and run it through the Database tuning Adviser
If you do, test carefully all of its recommendations (same goes for missing indexes)...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2010 at 5:32 am
GilaMonster (9/9/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2010 at 5:04 am
Not sure I understand you.
Splitting the database into multiple files is not going to help performance if all the files are on the same physical drive. Doesn't matter where on...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2010 at 4:57 am
Thanks. It's a 3-part series, so check parts 2 and 3 if you haven't already.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2010 at 4:49 am
If there's only one disk, then you have nowhere else to create the files and there's little point in doing so. There's little performance benefit from multiple files on the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2010 at 4:48 am
You can run a trace for a period of time and count up the queries. You can save perfmon counters, specifically the Batch_requests per second I think would be a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2010 at 4:45 am
Viewing 15 posts - 30,811 through 30,825 (of 49,552 total)