Viewing 15 posts - 39,961 through 39,975 (of 49,552 total)
Why do you want to shrink your log files?
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 6, 2009 at 12:46 am
pandeharsh (4/6/2009)
If i don't use group by or distinct,i get lot of records.
You've got duplicate rows because you've got a cross join. You have both table1 and table2 in the...
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 6, 2009 at 12:46 am
Achtang (4/5/2009)
with proper indexes or more memory?
Yes.
It depends where the problem is. If your indexing is not good, look to the indexes. If the indexes are good, add memory.
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 6, 2009 at 12:38 am
Achtang (4/5/2009)
do you set up Perfmon or SQL Trace?
As I said, Perfmon. SQL Trace won't tell you if you have an IO bottleneck. The disk counters within perfmon will...
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 5, 2009 at 2:02 pm
Achtang (4/5/2009)
you use dmv sys.dm_os_wait_stats and in this if you find many threads at PAGEIOLATCH then you can confirm that there is a problem with I/O subsystem
No.
If you find lots...
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 5, 2009 at 12:24 pm
It is possible to have excessive latch waits. Normally they fall into two categories:
1) Contention in TempDB
2) Slow IOs
Contention in TempDB
On SQL 2000 it was very likely, if TempDB was...
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 5, 2009 at 11:47 am
Latches are light-weight synchronisation constructs that are designed to protect the physical integrity of a page in a similar way to how locks protect the logical consistency of rows. They're...
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 5, 2009 at 11:04 am
This is a good place to start - http://msdn.microsoft.com/en-us/library/ms130764(SQL.90).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
April 5, 2009 at 3:54 am
Paul White (4/5/2009)
If the rule is unwritten then how was the OP supposed to be aware of it?
I never said they had to be aware of it. That comment was...
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 5, 2009 at 2:46 am
Got a backup? If so, restore that.
Are all the mdf files the same name? What's the modified date on the files? Do you have the ldf file as well?
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 5, 2009 at 2:37 am
tdhall_75233 (4/5/2009)
When trying to access from VS using C# the db is always in use when I try to access it.
How are you trying to access it? (C# code)
What...
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 5, 2009 at 2:00 am
Paul White (4/5/2009)
RBarryYoung (4/4/2009)
Why would our helping you to get a job that you are apparently unqualified for be a good thing?
Why would your being rude to someone you have...
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 5, 2009 at 2:00 am
One thing I will suggest, if this does have to be done on the DB. Put an order by in place. As it currently stands, there's no guarantee that the...
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 4, 2009 at 9:11 am
I do know, but I'm curious. Why do you want to set the server's time through SQL? That should be something that's done maybe once, by the server admin. 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 4, 2009 at 9:05 am
Generally this is more appropriately done on the front end, as it's usually a formatting/display issue.
While Florian's solution works very nicely, in relational terms, the resulting rowset has three...
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 4, 2009 at 5:36 am
Viewing 15 posts - 39,961 through 39,975 (of 49,552 total)