Viewing 15 posts - 36,211 through 36,225 (of 49,552 total)
SQL uses a proportional fill algorithm if there are two data files in a filegroup. So if there are two files (the same size), both empty, the table/index will be...
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
October 19, 2009 at 10:33 pm
Philip Millwood-419646 (10/19/2009)
By the same token, I'm guessing that replication is part of why the log file recovery is taking so long based on a couple things I've found.
Shouldn't be....
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
October 19, 2009 at 10:18 pm
Because seeks are not always optimal, especially when the actual data row is required (as in an update or a non-covering nonclustered index) and the rows affected is a significant...
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
October 19, 2009 at 10:14 pm
How big is your log file? Do you perhaps know how much of it was active before the restart?
For that matter, how big's the data file?
Have you changed recovery interval...
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
October 19, 2009 at 2:30 pm
Adam Bean (10/19/2009)
GilaMonster (10/19/2009)
What happens if you try and start SQL from the command line? For the default instance, go to the directory with the executable and just run sqlservr.exe
Hi...
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
October 19, 2009 at 10:34 am
mr_adeelalisyed (10/19/2009)
You were right I’ve notice Service Broker start but then stop. And this is why Server is not able to start.
Nope, other way around. Service broker is stopping because...
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
October 19, 2009 at 10:31 am
What happens if you try and start SQL from the command line? For the default instance, go to the directory with the executable and just run sqlservr.exe
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
October 19, 2009 at 10:24 am
Eddie Hendrix (10/19/2009)
Does anyone know why MSDB is having this issue and nothing else?
What are the messages in the error log relating to MSDB?
Please in future can you start 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
October 19, 2009 at 9:59 am
No. Moving any of the files of a database require that the database is offline or detached.
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
October 19, 2009 at 9:57 am
Avg disc sec/read?
Avg disk sec/write?
Queue length isn't a great measure with a SAN. Is 500 MB/sec a good throughput for your SAN?
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
October 19, 2009 at 9:23 am
endeavour (10/19/2009)
has anyone actualy hired a consultant to advise on SQL performance issues or to help your SQL database scale?
My introduction to performance tuning was when the company I...
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
October 19, 2009 at 9:19 am
SQL Error log?
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
October 19, 2009 at 9:11 am
Philip Millwood-419646 (10/19/2009)
Recovery is progressing-- albeit slowly. It is now at 50%
Ok, so you are seeing the "recovery is 50% complete..." messages?
Last time I saw a recovery taking this...
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
October 19, 2009 at 9:07 am
Check the SQL error log as well (text file called ERRORLOG). It will give the reasons why the service failed to start
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
October 19, 2009 at 8:43 am
To restore a database to a particular point in time you need a full backup from before that time and all the log backups from the time of the full...
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
October 19, 2009 at 8:43 am
Viewing 15 posts - 36,211 through 36,225 (of 49,552 total)