Viewing 15 posts - 10,516 through 10,530 (of 49,552 total)
A threshold should be above what is normal for your server.
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 2, 2014 at 12:46 am
JohnFTamburo (12/31/2013)
Hi.As much as I hate loops, this is the right place for one in order to remove the data without ballooning the transaction log.
Loops don't prevent log growth. 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
January 2, 2014 at 12:09 am
Ed Wagner (12/9/2013)
with cte as (
select top 100000 oid
from problem_table
...
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 2, 2014 at 12:07 am
Why is 2 logins/sec the threshold and is this a problem? What's normal for this server?
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 2, 2014 at 12:03 am
One table. 500 rows is nothing, 200 000 rows per year is nothing. 365 tables per year is horrible.
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 1, 2014 at 6:56 am
And the error you got 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
December 31, 2013 at 5:21 am
ifts? You have full text enabled (and possibly set up with partitioning?) If so, drop your full text indexes, you can always rebuild them later if you need them
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
December 31, 2013 at 3:49 am
That query just shows that you have no tables or indexes created on any partition schemes, not that you have no partition schemes.
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
December 30, 2013 at 3:28 pm
Revenant (12/30/2013)
For performance tuning, I would reword it as "Measure often, tune when needed."
I was just thinking exactly that.
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
December 30, 2013 at 9:11 am
isuckatsql (12/30/2013)
Since i did not, i deleted the table from the DB and the partitions from my hard drive, assuming that would do the job.....WRONG !
That will indeed...
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
December 30, 2013 at 9:08 am
wolfkillj (12/30/2013)
is there really a performance problem or are you just "tuning" the query as a knee-jerk response to seeing a scan in the execution plan or some similar shibboleth?
Exactly.
I'm...
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
December 30, 2013 at 9:01 am
Updates to the system tables are not allowed.
What are you trying to do? If you want to remove partitions you should be using ALTER TABLE and merge the partitions or...
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
December 30, 2013 at 6:43 am
Parameter sniffing, or more accurately lack thereof. http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/
Try this, and note the slight changes I made to the dates and date comparison as well, as the original version could miss...
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
December 30, 2013 at 5:12 am
Ok, after another frustrating thread of 'why do you want to remove that operator from the query, is it causing problems', the next article on the to-do list (after I...
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
December 30, 2013 at 1:44 am
Have a look through the error log, find the errors that state why SQL is marking that database recovery_pending.
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
December 29, 2013 at 12:18 pm
Viewing 15 posts - 10,516 through 10,530 (of 49,552 total)