Viewing 15 posts - 9,016 through 9,030 (of 49,552 total)
jcrawf02 (5/19/2014)
GilaMonster (5/16/2014)
The Wheel of Time turns, and Ages come and pass.
What was, what will be, and what is,
may yet fall under the Shadow.
Let 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
May 19, 2014 at 7:10 am
Oracle_91 (5/19/2014)
Neither. It'll be discarded.
Gail, just checking what if it is ongoing transaction.
Same thing. If there's memory pressure, SQL will discard pages from the data cache to make space...
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
May 19, 2014 at 7:05 am
Oracle_91 (5/19/2014)
Now my question is, whether the flushed out data will be placed/pageout to OS pagefile or it spills to tempdb.
Neither. It'll be discarded.
Next time the data is needed...
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
May 19, 2014 at 4:28 am
Probably some long-running transaction which had to be rolled back.
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
May 19, 2014 at 4:23 am
No. As far as I'm aware, no changes have been made to how DTA works for years.
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
May 19, 2014 at 4:20 am
The change in recovery model on the primary DB broke the log chain. You won't be able to take another log backup until you take a full/diff to restart 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
May 19, 2014 at 4:18 am
The Virtual File Stats DMV, like many of the stats you get from DMVs are stored in memory, are specific to an instance and are cleared when SQL restarts.
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
May 19, 2014 at 4:16 am
No where near enough information. We need at minimum the procedure definition and the table definitions, the execution plan as well would be extremely useful
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
May 18, 2014 at 3:18 pm
That is the current plan, not sure exactly what time exactly. Was planning to beg for a lift through to Telford (and for Sunday too)
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
May 18, 2014 at 3:14 pm
That article was written using SQL 2008, so yes.
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
May 18, 2014 at 9:30 am
Recovery process should be logged to the error log. Yes, you just have to wait.
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
May 18, 2014 at 5:43 am
https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-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
May 17, 2014 at 10:58 am
The statement you posted should bring it online, you'll just have to wait while SQL runs the recovery process.
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
May 17, 2014 at 10:57 am
If 2008 (100) is not in the list then you're connected to the SQL 2005 instance.
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
May 16, 2014 at 4:31 pm
Honestly, seriously, recommend to your client (and your company) that they look for a DB specialist to help them with their DR and that they let you work on your...
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
May 16, 2014 at 2:45 pm
Viewing 15 posts - 9,016 through 9,030 (of 49,552 total)