Viewing 15 posts - 30,976 through 30,990 (of 49,552 total)
Profiler is included in every edition other than Express.
It won't be deadlocks, they give different errors (error 1205 if I recall). A timeout is a client-side error where the client...
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
August 31, 2010 at 11:15 am
The maintenance plan adds a timestamp to the filename.
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
August 31, 2010 at 9:48 am
No. Absolutely not.
Constant shrink/grow causes all sorts of subtle performance problems.
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
August 31, 2010 at 9:18 am
paul.knibbs (8/31/2010)
GilaMonster (8/31/2010)
Since they are variable-length columns, inserts won't fail, the excess data will be pushed off page. Row Overflow. Will do terrible things for performance.
Doesn't that depend 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
August 31, 2010 at 8:58 am
WayneS (8/31/2010)
GilaMonster (8/31/2010)
I tend to use the term 'Database Specialist', as I do everything around DBs, architecture, admin, dev, BI, optimisation, DR, etc.
Over here in the US, we tend to...
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
August 31, 2010 at 8:49 am
Not sure why CheckDB's not picking this up, but the following should fix it. Do this in a maintenance window if possible.
Full backup
Switch to simple recovery
Checkpoint
Switch to full recovery
Full backup
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
August 31, 2010 at 8:00 am
Does a full backup work?
p.s. Is there any more info in the SQL error log (as the error indicates)
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
August 31, 2010 at 7:39 am
WayneS (8/31/2010)
(So, what IS your title anyway? DBA Trainer? DBA Mentor? 😎 )
Consultant.
I don't have an official title. Not necessary in a company < 15 people most of whom are...
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
August 31, 2010 at 7:39 am
Ramji29 (8/31/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
August 31, 2010 at 7:15 am
Matt-1034261 (8/31/2010)
GilaMonster (8/31/2010)
DB I used to work with had a 250GB log file. Make sure that you're maintaining it correctly and don't worry too much.
And therein lies 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
August 31, 2010 at 6:22 am
Grant Fritchey (8/31/2010)
Based on three questions in just a few minutes, are you in an interview?
If so, with what company?
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
August 31, 2010 at 6:19 am
Blocking by itself is not a problem. It's expected as part of a database system. Excessive (long-duration) blocking usually indicates poorly written queries or poor indexing. Look at optimising 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
August 31, 2010 at 6:17 am
Ramji29 (8/31/2010)
Check log_reuse_wait_desc in sysdatabases table ...
log_reuse_wait_desc is not in sysdatabases (which is a backward compatibility view). It's in sys.databases.
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
August 31, 2010 at 6:15 am
DB I used to work with had a 250GB log file. Make sure that you're maintaining it correctly and don't worry too much.
Managing Transaction Logs[/url]
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
August 31, 2010 at 6:13 am
ionas (8/31/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
August 31, 2010 at 6:01 am
Viewing 15 posts - 30,976 through 30,990 (of 49,552 total)