Viewing 15 posts - 44,701 through 44,715 (of 49,552 total)
Rem (9/3/2008)
By setting Processors Affinity & I/O Affinity, Am I OK, or I should totally disable HT?
You should disable it completely, if you can. If not, then a workaround 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
September 3, 2008 at 9:16 am
ALZDBA (9/3/2008)
Gail,Do you have a kb ref for the min = max memory config problem ?
How about books online:
Optimizing Server Performance Using Memory Configuration Options
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
September 3, 2008 at 9:13 am
This may be useful:
http://blogs.technet.com/askperf/archive/2008/03/25/lock-pages-in-memory-do-you-really-need-it.aspx
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
September 3, 2008 at 9:01 am
rbarryyoung (9/3/2008)
To the best of my knowledge, Hyperthreading is not recommended for SQL Server.
It's not. SQL 2005 handles it better than SQL 2000 did, but still... Can lead to random,...
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
September 3, 2008 at 8:47 am
Get a bigger drive.
If you're putting data into the database it is going to grow. You can look at archiving or deleting data that's no longer necessary, 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
September 3, 2008 at 7:26 am
Is you coworker asking for separate servers or separate virtual servers?
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
September 3, 2008 at 7:24 am
Don't shrink your database at all. It causes very bad index fragmentation and the DB will just grow again next time some data is added or those fragmented indexes 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
September 3, 2008 at 7:13 am
You can. If you haven't made changes to the model database, it's not necessary.
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
September 3, 2008 at 6:54 am
I don't. It was mentioned in a presentation. I'll see if I can find a ref for you.
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
September 3, 2008 at 6:31 am
Keyword filters aren't a very good way of defending against SQL injection.
1) Use only procedures (preferably) or parameterised queries from your front end apps.
2) Ensure that the app user has...
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
September 3, 2008 at 3:18 am
What was the error when the service didn't start? There would have been something in the SQL error log.
Install
Patch
Ensure that the user DB files are in the same location as...
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
September 3, 2008 at 1:11 am
gcg_wilkinson (9/2/2008)
I've found that even if u defrag an index and the physical disk is fragmented, then the index will remain fragmented.
It shouldn't contribute to the logical fragmentation. That's defined...
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
September 3, 2008 at 12:16 am
Is the min and max memory set to the same value? If so, please change that, there's a problem whereby if they are identical then some of SQL's memory management...
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
September 3, 2008 at 12:12 am
Main perf problem is that indexes on an encrypted column are useless. The encryption routines are no deterministic and so you can't encrypt a value and compare with the encrypted...
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
September 2, 2008 at 2:02 pm
Very strange.
Are there any common traits about the slow iterations? Certain user, certain time, certain parameters?
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
September 2, 2008 at 1:48 pm
Viewing 15 posts - 44,701 through 44,715 (of 49,552 total)