Viewing 15 posts - 5,101 through 5,115 (of 5,843 total)
I still submit that the most cost effective thing you can do is hire a decent perf consultant for a limited tuning analysis engagement.
June 26, 2008 at 4:06 pm
Glad performance improved. It is simply amazing how often IO is the cause of poor database performance.
My quickie review of your perfmon reveals the following:
1) Avg CPU is pretty...
June 26, 2008 at 7:48 am
I would like to add that it has been my experience that SAN vendor consultants know VERY little about how to optimally configure a SAN for SQL Server storage needs....
June 26, 2008 at 7:28 am
Up to a point, having lots of spids sleeping won't affect performance. This is normal with thread pooling.
You stated that you had no blocking and no long-running queries (which I...
June 26, 2008 at 7:25 am
DTA is like any other tool: if you KNOW how it works and how to use it it can be an effective device. But I have had two...
June 24, 2008 at 7:24 am
Well, I am at a loss here. I really REALLY thought I had given sufficient proof that if you use TOP/ORDER BY on a clustered column the distribution and...
June 23, 2008 at 3:40 pm
noeld (6/23/2008)
The cost shows as 14.7% higher (a clear win), but the page reads and amount of data put through the CPUs is identical. The only difference in the...
June 23, 2008 at 12:49 pm
All I am saying is that SELECT TOP 100 * ... ORDER BY without a WHERE CLAUSE is not a good thing especially when you cluster by TIME. Limiting the...
June 23, 2008 at 11:17 am
noeld (6/23/2008)
TheSQLGuru (6/20/2008)
noeld (6/20/2008)
you must definitely "limit" the Time column with a "range" once you do that you should be fine.
This is being done. The combination of top 100...
June 23, 2008 at 10:17 am
1) a covering index is an inappropriate suggestion for a query that returns all columns
2) reducing the number of columns could well be appropriate and that could allow for covering...
June 23, 2008 at 9:19 am
1) It is only a rare situation where you should turn off auto stats features
2) I would have a job that runs at an appropriate interval (which depends on your...
June 23, 2008 at 9:15 am
1) are you sure there wasn't blocking going on when the sproc was executing?
2) Like others asked, we need to see the code, query plans and IO information (set statistics...
June 23, 2008 at 8:53 am
rbarryyoung (6/20/2008)
TheSQLGuru (6/20/2008)
Maybe take a look at ApexSQL's Script product, or search the web for some SMO code that will script out objects for you.
Not necessary. As I demonstrated...
June 20, 2008 at 5:32 pm
Maybe take a look at ApexSQL's Script product, or search the web for some SMO code that will script out objects for you.
June 20, 2008 at 1:25 pm
noeld (6/20/2008)
you must definitely "limit" the Time column with a "range" once you do that you should be fine.
This is being done. The combination of top 100 and order...
June 20, 2008 at 1:23 pm
Viewing 15 posts - 5,101 through 5,115 (of 5,843 total)