Viewing 15 posts - 39,721 through 39,735 (of 49,552 total)
Is there any combination of columns that's frequently filtered 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
April 15, 2009 at 9:55 am
It depends on the reason that the DB is suspect. Please have a look at the SQL error logs for any errors that refer to that database. Post them here.
Do...
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
April 15, 2009 at 9:48 am
Then check other jobs that run at the same time. I don't know if it's possible to have custom scripts in a maint plan, if so check them. SQL won't...
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
April 15, 2009 at 8:09 am
Chris Morris (4/15/2009)
Anyone for pork chops?
I love it when people are dead wrong with complete confidence.
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
April 15, 2009 at 7:41 am
Chris Morris (4/15/2009)
krayknot (4/15/2009)
If you are using any variable(s) as an OUTPUT varialbe in stored procedure, it means that variable will carry the output of the stored procedure.
Are 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
April 15, 2009 at 7:33 am
Is this an existing app, or one in planning?
If it's existing, I would suggest you trace the server for a couple hours and see what the most common queries 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
April 15, 2009 at 7:31 am
Probably because somewhere in the backup job there's code that switches the recovery model to simple and back to full. SQL won't just change the recovery model by itself. If...
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
April 15, 2009 at 7:26 am
Maybe I'm missing something, but why is it a concern which it is? If you know the material, case study or no case study shouldn't matter.
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
April 15, 2009 at 6:29 am
montgomerybrothers (4/15/2009)
So is there anyway to add rep or give points on this board?
No. Points here are purely from posting and from answering the Question of the Day.
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
April 15, 2009 at 6:13 am
Can you at least post the DDL for Request and Request type, including indexes, and the query in question?
By the looks of the screen shots this is a SQL 2000...
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
April 15, 2009 at 6:11 am
samartel (4/15/2009)
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
April 15, 2009 at 6:08 am
Grant Fritchey (4/15/2009)
GilaMonster (4/15/2009)
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
April 15, 2009 at 6:07 am
Plus index rebuilds update statistics, so if you have regular complete index rebuilds that may take care of the stats.
Honestly, on systems that I've maintained, I've only seen two tables...
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
April 15, 2009 at 2:29 am
It may not be just view vs procedure. It may be that the second query the data was in cache and hence didn't have to be fetched from disk. 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
April 15, 2009 at 2:22 am
SQL does update statistics automatically. It's when that it switched off, or doesn't happen often enough that you have to manually update the stats.
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
April 15, 2009 at 2:21 am
Viewing 15 posts - 39,721 through 39,735 (of 49,552 total)