Viewing 15 posts - 20,221 through 20,235 (of 49,552 total)
What wait type?
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 20, 2012 at 2:39 am
Please read through this - Managing Transaction Logs[/url] and this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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 20, 2012 at 2:37 am
WRACK (2/19/2012)
GilaMonster (2/19/2012)
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 20, 2012 at 2:36 am
Just a point, if SQL is not on a dedicated server, then setting a sensible max server memory is almost essential. It's recommended even on a dedicated server, especially of...
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 19, 2012 at 3:50 pm
The blog-related threads seem to be mostly gone. I noticed a couple during the week (see page or so earlier in the thread), but none this weekend. I think 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
February 19, 2012 at 3:47 pm
It has to do with type precedence and what happens when you add different data types together.
In the first, you're adding a smallmoney and an int and getting a result...
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 19, 2012 at 11:24 am
sumitagarwal781 (2/19/2012)
Rowles (2/18/2012)
2) There are multiple ndfs and one mdf as opposed to one mdf file.Nice article on performance with multiple filegroup.
http://www.sql-server-performance.com/articles/per/optimize_filegroup_performance_p1.aspx
Pity it's wrong in a few key places.
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 19, 2012 at 4:58 am
Clustering is solely a high-availability solution, it has no impact on performance at all.
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 19, 2012 at 3:22 am
It's not about maint plan vs T-SQL. It's about targeted, sensible maintenance not everything.
2 is not necessarily true, and multiple filegroups doesn't really make maintenance harder
3 - backups on VLDBs...
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 19, 2012 at 3:21 am
Check event logs and driver versions on the server too. Cause may not be the SAN, could be anything in the IO stack from filter drivers right down to 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
February 19, 2012 at 3:18 am
GilaMonster (2/18/2012)
Typically you'd load balance...
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 19, 2012 at 3:17 am
I checked with an expert and he's pretty sure that the page restores won't affect the replication, the page restore will just be bringing the page up to current state...
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 18, 2012 at 2:26 pm
Schema is never a database. Schema is, well, a schema a logical grouping of objects within a database. The object can be anything, table, view, procedure, function, etc, they're all...
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 18, 2012 at 12:30 pm
Why don't you try them and see? Easy to test.
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 18, 2012 at 12:29 pm
Update locks are compatible with shared locks, exclusive are not. An update first takes update locks on all of the rows it need to update and then, once it has...
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 18, 2012 at 12:27 pm
Viewing 15 posts - 20,221 through 20,235 (of 49,552 total)