Viewing 15 posts - 13,936 through 13,950 (of 49,552 total)
kaplan71 (3/10/2013)
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
March 11, 2013 at 7:16 am
If server maxdop is 0 then it's pointless specifying maxdop on the index unless you want to reduce the number of processors it is allowed to use.
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
March 11, 2013 at 7:12 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/Topic1429193-2799-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
March 11, 2013 at 7:10 am
Profiler or Extended Events (or a 3rd party tool that will use one of 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
March 11, 2013 at 6:34 am
Syncing the jobs is the easy part, just copy them to the other servers. You just need some check in the job to ensure that it won't run on 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
March 11, 2013 at 6:32 am
A single update statement can only update a single table, that's in any version of SQL 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
March 11, 2013 at 6:21 am
Just the jobs? What about the databases those jobs connect to? What HA/DR do they have set up?
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
March 11, 2013 at 6:16 am
JP-1019544 (3/11/2013)
There is definitely more data as it is a subset, but it takes MUCH more time to pull the Subset data.
Did you check out the blog post I referenced?
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
March 11, 2013 at 5:52 am
Profiler or extended events. Bear in mind you're looking at large volumes of data. I have a moderately busy server that, just by capturing what a user runs, generates 300MB...
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
March 11, 2013 at 5:51 am
Could you be more specific? Fail over when, to what, etc.
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
March 11, 2013 at 5:49 am
mah_j (3/11/2013)
Can I use MaxDop = Number of processors in main server?
Unless the server maxdop setting has been set to something other than the default (0), that won't have any...
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
March 11, 2013 at 5:44 am
Bhuvnesh (3/11/2013)
1) There could be less data in that range....
but i still vote the first reason.
How could there be less data between '2013-01-01' and '2013-01-31' than there is between '2013-01-09'...
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
March 11, 2013 at 5:23 am
Direct manipulation of the sharepoint database will void your support and may break sharepoint if you're not careful. Any manipulation of the sharepoint database should be done through the sharepoint...
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
March 11, 2013 at 5:16 am
Full and log backups don't block each other (since SQL 2005), don't know about diff and log.
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
March 11, 2013 at 5:01 am
This perhaps
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
March 11, 2013 at 5:00 am
Viewing 15 posts - 13,936 through 13,950 (of 49,552 total)