Viewing 15 posts - 41,416 through 41,430 (of 49,552 total)
llokshin (1/26/2009)
But when our IT ran chckdisk on it it repported 0 errors.
Still, if it's giving errors there's a problem. You don't want to find the problem when the drive...
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
January 26, 2009 at 11:13 am
Jeff Moden (1/26/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
January 26, 2009 at 11:07 am
Ed (1/26/2009)
Does it matter which column is defined in the clustered index?
Yes! Very much so. A bad choice of a cluster can do terrible things to performance. Uniqueindentifier...
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
January 26, 2009 at 10:22 am
That looks like problems with the IO subsystem. Possibly intermittent right now.
Check the windows event log for anything indicating hardware problems, check the SQL error log, check any logs from...
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
January 26, 2009 at 9:59 am
Cricketdogger (1/21/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
January 26, 2009 at 9:53 am
srihari nandamuri (1/26/2009)
Take corrective action
What kind of corrective action are you proposing?
Dropping indexes that haven't been used since the last server start is not recommended, unless you're very...
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
January 26, 2009 at 9:52 am
P Jones (1/26/2009)
I also get hot under the collar about bad spelling and grammar - I had a traditional English grammar school education
Just bear in mind that not everyone...
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
January 26, 2009 at 9:45 am
Has your job been doing full backups, or transaction log backups? In full recovery, you need both.
Please read through this - Managing Transaction Logs[/url]
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
January 26, 2009 at 9:38 am
Steve Jones - Editor (1/25/2009)
Personally I dislike labeling things bad and good, especially with code since it's a question of where and when things make sense.
If you've read my blog...
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
January 26, 2009 at 9:36 am
David.Poole (1/26/2009)
I've heard that if an index grows beyond a certain point SQL Server is unable to use it.
May I ask where you heard that from?
As far as I know,...
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
January 26, 2009 at 9:36 am
Ed (1/26/2009)
IX_sysValidationList is a unique, non-clustered index on the column, ValidationPartyID. Is this index not appropriate for these joins?
Apparently not. Probably because it's not covering. I haven't looked at...
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
January 26, 2009 at 9:33 am
So the database size is 72GB, the unallocated space is 3GB
Then the reserved size is 69 GB, the data is 31 GB, the indexes are 38 GB and the unused...
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
January 26, 2009 at 12:54 am
Looks fine. I'll take a detailed look later.
One thing I can tell you straight off, there's no clustered index on the table that you're repeatedly joining to, and no useful...
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
January 26, 2009 at 12:43 am
thulani.moyana (1/25/2009)
I would like to find out if one can rely on the tuning advisor and implement all of its recommendations?
No.
The DTA does an OK job. Not great, but...
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
January 26, 2009 at 12:38 am
Please post in the appropriate forum in the future.
Temp tables are treated the same way (almost) as permanent tables. So creation of a temp table will force a proc 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
January 26, 2009 at 12:35 am
Viewing 15 posts - 41,416 through 41,430 (of 49,552 total)