Viewing 15 posts - 29,536 through 29,550 (of 49,552 total)
Roy Ernest (11/5/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
November 5, 2010 at 11:46 am
SKYBVI (11/5/2010)
So, that means that the combination of hte 2 steps decreases log files not individual steps.
No, it does not! The two 'steps' do different things and I know...
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
November 5, 2010 at 11:35 am
SKYBVI (11/5/2010)
After the backup log script , i had to manually shrink the log files thru SSMS(tasks-->shrink-->files), then the size got dereased
EXACTLY what I was saying all along.
From earlier...
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
November 5, 2010 at 11:17 am
SKYBVI (11/5/2010)
I did backup log with truncate_only.
If file size reduced after that then you have autoshrink on. For the health of your database, turn it off.
p.s. You should never 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
November 5, 2010 at 10:47 am
SKYBVI (11/5/2010)
That 20 gb increase is just in 1 week,
If TempDB is growing, you have some bad code somewhere, long running transactions or similar. Find and fix the cause. Trying...
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
November 5, 2010 at 10:28 am
SKYBVI (11/5/2010)
Tempdb mdf file and ldf file grow at a consistent rate on many of my servers.
Common cause of that is poorly written queries and/or bad indexing....
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
November 5, 2010 at 9:53 am
Derrick Smith (11/5/2010)
I wonder if Gail has a 6th sense and cringes every time a database shrinking post pops up...
Something like that...
Anyway, the reason your tempdb is 20 gigs 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
November 5, 2010 at 9:50 am
C# Screw (11/5/2010)
This I could do in my FoxPro days, but in SQL it seems that at least a page locked.
No, SQL locks at row, page or table depending 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
November 5, 2010 at 9:26 am
Please note this is a CTP, not a final release. I suggest that you don't install on any server that you are not willing to reinstall.
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
November 5, 2010 at 2:25 am
None of those waits are IO related.
The IO related waits are PAGEIOLatch_XX. Those latches are all memory-related latches. Without knowing more of your setup and what queries you're running...
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
November 5, 2010 at 2:23 am
sql.monkey (11/4/2010)
If you lose any of those transactions youre company is liable.
How often do...
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
November 5, 2010 at 2:19 am
A view doesn't store data. A view is just a saved SQL statement. If you update a view the update is pushed to the base table. Since you don't want...
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
November 4, 2010 at 4:41 pm
Open the scripts in an editor and do a search and replace?
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
November 4, 2010 at 1:46 pm
Alvin Ramard (11/4/2010)
Lynn Pettis (11/4/2010)
Gail, Sounds like all future informal conversations will need to include a member of management.Or PA System
I'm seriously considering getting a voice recorder and recording all...
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
November 4, 2010 at 1:42 pm
Lynn Pettis (11/4/2010)
Gail, Sounds like all future informal conversations will need to include a member of management.
The 'informal conversation' today (3rd time same issue) had the Project manager present, just...
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
November 4, 2010 at 1:40 pm
Viewing 15 posts - 29,536 through 29,550 (of 49,552 total)