Viewing 15 posts - 61 through 75 (of 152 total)
djjwu (6/9/2009)
I personally think 1m tlog backup is too much. 🙂
For any particular reason (performance, IO, space etc) or just the best practice?
Agreed that it's too much but then what...
June 9, 2009 at 1:01 pm
This is a critical product licensing system so cannot loose more than one minute of data that's why we selected these intervals. And we didn't see any performance hit due...
June 9, 2009 at 11:18 am
GilaMonster (6/9/2009)p.s. diffs every 15 min and log backups every minute? That's a lot of backups.
This is becuase we have log shipping implemented for high availability, do you still think...
June 9, 2009 at 11:07 am
GilaMonster (6/4/2009)The only operations that truncate a log file are:
Log backups (in full/bulk-logged)
Checkpoint (in Simple)
does that mean, it is not possible to break the Log sequence as long...
June 5, 2009 at 8:23 am
Rob Goddard (5/14/2009)
If there are a lot of cols and you need them...
May 14, 2009 at 10:25 am
Christopher Stobbs (5/14/2009)
DECLARE @MyTable TABLE
(Id INT,
Team CHAR(1))
INSERT INTO @MyTable
SELECT 1, 'A' UNION ALL
SELECT 2, 'A' UNION ALL
SELECT 3, 'A' UNION ALL
SELECT 3, 'B'
SELECT
Id,MAX(Team)
FROM @MyTable
GROUP BY Id
Thanks for this...
May 14, 2009 at 10:21 am
Ramesh (5/14/2009)
Look for ROW_NUMBER() function with PARTITION BY clause in Books Online.
Thanks for replying Ramesh, i know ROW_NUMBER() function, but can you please explain how that can be used to...
May 14, 2009 at 10:19 am
Here is a wild thought, please respond with your views, is it possible that index values of the three tables are in the same memory page and sql server is...
May 7, 2009 at 6:31 pm
i donot have that information becuase this block was happend few hours ago. Please find attached the query that i am using to log this data, i appreciate if you...
May 6, 2009 at 1:23 pm
Actually i am logging the locks into a custom table using a sql script that i wrote, i have attached the file with the details of the blocks, please see...
May 6, 2009 at 1:06 pm
RBarryYoung (5/6/2009)
What PaulB said: we need to see what you saw in the Activity Monitor wrt to the locks.
I have provided the locks and resources in an earlier message.
May 6, 2009 at 12:47 pm
Thanks guys, i guess i have to live with it, but thanks for the explanations.
May 6, 2009 at 12:46 pm
PaulB (5/6/2009)
Good!... now show us the locks.
Query 2 has wait_type = "LCK_M_U" and wait_resource = "PAGE: 8:1:135798"
Query 3 has wait_type = "LCK_M_U" and wait_resource = "KEY: 8:72057596239085568 (4d03000fb951)"
May 6, 2009 at 12:42 pm
Viewing 15 posts - 61 through 75 (of 152 total)