Viewing 15 posts - 25,636 through 25,650 (of 49,552 total)
Is your environment clustered? Mirrored? If you have minimal downtime allowance it surely has one of those.
If so, failover. That's maybe a minute or two at most downtime.
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
June 8, 2011 at 10:11 am
Seriously, how often do you have to remove tempDB files?
For me (admittedly I'm not a production DBA, though I work a lot with them) it's 0 times in 6 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
June 8, 2011 at 10:00 am
It may seem overly simplistic, but at the core it's correct. SQL uses the files serially, never in parallel. Hence there's no advantage to having say 2 5GB log files...
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
June 8, 2011 at 9:57 am
Jim Murphy (6/8/2011)
I'm not much of a runner. Uh, at all. But with all of this peer...
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
June 8, 2011 at 9:20 am
This is specific and unique to tempDB and likely has to do with what uses tempDB and how it's used.
To determine that a TempDB data file can be dropped...
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
June 8, 2011 at 9:15 am
andersg98 (6/7/2011)
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
June 8, 2011 at 7:33 am
You can't attach or detach TempDB.
Additionally, that attach is to attach the primary file of a database. You can't just attach files to existing databases. Detach detaches the entire database,...
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
June 8, 2011 at 7:16 am
That's very likely to require a restart of the SQL Service (not a server restart)
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
June 8, 2011 at 7:11 am
User database or TempDB?
Can you explain the situation you're seeing?
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
June 8, 2011 at 6:59 am
bopeavy (6/8/2011)
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
June 8, 2011 at 6:41 am
So why even bother mentioning it or recommending it if it'll have no impact?
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
June 8, 2011 at 5:53 am
Fal (6/8/2011)
Didn't mean to imply you didn't, if it came across as such. Was alluding that the second half would be a wholly contained subset of the first half...
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
June 8, 2011 at 5:30 am
crazy4sql (6/8/2011)
But your downtime is...
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
June 8, 2011 at 5:26 am
SQL Server is a relational database management system, the entire of SQL Server, not a piece of it.
That page has decided to split it into two broad subsections, but that's...
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
June 8, 2011 at 4:51 am
Craig Farrell (6/8/2011)
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
June 8, 2011 at 4:32 am
Viewing 15 posts - 25,636 through 25,650 (of 49,552 total)