Viewing 15 posts - 43,816 through 43,830 (of 49,552 total)
Does this help?
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/storage-top-10.mspx
Basically, in my experience:
1) Log files on a separate RAID array
2) Data files (if there are multiple) on separate raid arrays
3) TempDB on its own set of dedicated...
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 13, 2008 at 12:54 pm
Can you post the table and index definitions please? Also the output of sp_spaceused for that table
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 13, 2008 at 12:45 pm
The only way that a SQL data or log file will decrease in size is if you explicitly shrink it or if you have autoshrink enabled (which is a bad...
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 13, 2008 at 12:43 pm
DBA (10/13/2008)
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 13, 2008 at 12:08 pm
David Lester (10/13/2008)
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 13, 2008 at 10:02 am
I'll add to that
7) Set up some performance monitoring so that you can establish a baseline of what's normal and what's not
8) Schedule index rebuilds/defrags as necessary
9) If in 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 13, 2008 at 10:01 am
wjones21 (10/13/2008)
No, not really any I/O bottlenecks.So, it's perfectly OK to eventually have a 1 TB single data file?
Usually before that point people will start splitting up, for recovery purposes....
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 13, 2008 at 9:57 am
That still only allows for a single row in inserted.
If multiple rows have been inserted, then your variable assignment (below) is going to assign values of one of those...
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 13, 2008 at 9:41 am
Looking at that, unless you're seeing IO bottlenecks (are you?) I doubt you'll see much if any improvement from the split. If you decide to split, then just add 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 13, 2008 at 9:03 am
Are you sure there's no one else with sufficient rights? Nothing got accidentally scheduled or run? The DTS package didn't perhaps have the wrong connection on a drop table task?
It...
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 13, 2008 at 8:58 am
thomas.lemesurier (10/13/2008)
This kind of works, except that in some cases there is more than one row in the Album table per album. For example, for a given album, the Album...
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 13, 2008 at 8:46 am
Splitting data into multiple files doesn't usually give much or any of a performance benefit, unless you're having IO performance issues. Are you encountering IO bottlenecks? Splitting into multiple 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
October 13, 2008 at 8:38 am
You can set the main plan to log all errors to a text file. In SQL 2005 and 2008 that's done by selecting the 'Reporting and Logging' button from 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
October 13, 2008 at 8:24 am
The best thing to do with deadlocks is find the cause and fix it. Typically deadlocks are caused by bad code, bad indexing or both.
Set traceflag 1204 on and SQL...
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 13, 2008 at 8:23 am
To alter a database there must be no connections to the DB, sleeping or otherwise. You can either kill the connections or you can use the rollback immediate option 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
October 13, 2008 at 8:18 am
Viewing 15 posts - 43,816 through 43,830 (of 49,552 total)