Viewing 15 posts - 14,116 through 14,130 (of 49,552 total)
You can add the new file on the D drive, you have allocation contention, not IO contention (unless there are additional problems you haven't mentioned.
If TempDB is growing to 1.5...
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
February 27, 2013 at 10:10 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1424621-146-1.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
February 27, 2013 at 10:07 am
Are the lookups a problem?
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
February 27, 2013 at 8:32 am
Some details on index column ordering
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
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
February 27, 2013 at 8:19 am
They can be, but the resultant index will be less efficient for queries that filter on anything other than A, B than the individual indexes would have been.
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
February 27, 2013 at 7:57 am
Or switch them into a partioned archive table and maybe merge the partitions.
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
February 27, 2013 at 7:54 am
Benki Chendu (2/27/2013)
Do you have any idea on this? Would a service pack upgrade help here?
No idea whatsoever. Call MS support and open a case with them (yes, there is...
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
February 27, 2013 at 7:54 am
The entire point of partitioning is ease of archiving and easier maintenance. It's not a performance tuning technique.
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
February 27, 2013 at 7:19 am
What's the point of encrypting? Who are you trying to protect the data against?
Look at the SQL functions EncryptByKey and EncryptByCert
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
February 27, 2013 at 7:02 am
http://technet.microsoft.com/library/Cc966545
http://www.sqlskills.com/blogs/paul/category/tempdb/
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
February 27, 2013 at 6:51 am
If you need urgent help on a rather odd problem, open a case with Microsoft support.
We're all volunteers here, we post in our spare time.
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
February 27, 2013 at 6:50 am
700.
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
February 27, 2013 at 6:47 am
Perry Whittle (2/27/2013)
GilaMonster (2/26/2013)
You could call the transaction log file readme.txt if you wantedI bet someone, somewhere in the world has too 🙂
For the sake of playing around, I once...
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
February 27, 2013 at 6:47 am
aviadavi (2/27/2013)
what shall I try now?
What Lynn suggested right at the beginning.
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
February 27, 2013 at 6:46 am
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
February 27, 2013 at 2:27 am
Viewing 15 posts - 14,116 through 14,130 (of 49,552 total)