Viewing 15 posts - 46,036 through 46,050 (of 49,552 total)
jsheldon (6/30/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
June 30, 2008 at 2:38 pm
Jeff Moden (6/30/2008)
Dang.... that's exactly what they did at the place I work... the worst part is... the DBA recommended it! 😉
Here too, except the previous database architect recommended 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
June 30, 2008 at 8:13 am
anjan.ashok (6/30/2008)
I think the issue is with the version the instance showiing error version is 9.0.1399 and other instance in which maintainance job ran fine version is 9.0.3054
I thought 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
June 30, 2008 at 8:07 am
It's possible that you are bottlenecked on IO (likely) or memory, and hence the CPU can't get to full utilisation. In gneral, you don't want to see your CPU more...
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
June 30, 2008 at 8:05 am
Do the instances that do work have SSIS installed on them?
I seem to recall that in 2005 RTM (which is what you're running) maint plans required SSIS.
You may want 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
June 30, 2008 at 7:57 am
Grant Fritchey (6/30/2008)
Needless to say, he couldn't answer the questions and wasn't brought in for the full interview.
Gee. I wonder why...
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
June 30, 2008 at 7:56 am
There's no file-processor affinity for any database other than TempDB.
The recomendation I've seen for user databases is that they should have a max number of data files = 0.25...
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
June 30, 2008 at 7:49 am
Grant Fritchey (6/30/2008)
We ask 10 questions. They're stupid simple. Yet people with "10 years advanced experience" don't know the difference between a clustered and non-clustered index.
Likewise. I had an...
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
June 30, 2008 at 7:42 am
Paritioning may help, without seeing more info on the table design and delete statement I can't be more specific than that.
The async model may very well help. Scheduling the deletes...
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
June 30, 2008 at 7:29 am
anjan.ashok (6/30/2008)
one more question if the data file is growing rapidly wat the solution its taking more space.alteast log files we can shrink right.
Find out why the database is growing....
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
June 30, 2008 at 7:29 am
anjan.ashok (6/30/2008)
I am shrinking database once in a week.
It is not recommended to shrink databases on a regular basis. If you insist on doing it, make sure that you rebuild...
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
June 30, 2008 at 7:18 am
Do not, do not, do not regularly shrink your data files! It causes lots of fragmentation and the data files will just have to grow again. Databases need some free...
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
June 30, 2008 at 7:03 am
In general, no, and you mostly don't want to force the optimiser to do things a specific way, as it usually knows better.
Could you post the execution plans in xml...
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
June 30, 2008 at 6:58 am
That very much depends on what you want. Business Intelligence isn't a product. It's a term encompassing a several different products and technologies.
Could you please give a little more info...
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
June 30, 2008 at 4:28 am
Please don't cross post. It just wastes people's time and fragments replies. In addition, posts on SQL 2000 should be made in the sQL 2000 forums.
No replies to this thread...
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
June 30, 2008 at 4:26 am
Viewing 15 posts - 46,036 through 46,050 (of 49,552 total)