Viewing 15 posts - 44,491 through 44,505 (of 49,552 total)
You can monitor the transaction/sec via perfmon (SQL Server: Databases (tempDB)), then you can look a the IO throughput with the sys.dm_io_virtual_file_stats DMV. It's cumulative since SQL last started, so...
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
September 15, 2008 at 10:12 am
Depends highly on the queries. It could be that your indexes aren't covering and that with the number of rows been returned, SQL decided that a scan of the cluster...
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
September 15, 2008 at 9:44 am
Richard McSharry (9/15/2008)
There appears to be some disagreement about clustering, but I think the consensus is that it's only a DR solution and not a scale-out solution.
Absolutely, because the separate...
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
September 15, 2008 at 9:34 am
The explanation for that counter is:
% Processor Time is the percentage of elapsed time that all of process threads used the processor to execution instructions.
So it's (cpu time/elapsed time)*100
How...
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
September 15, 2008 at 9:15 am
You could also look at moving the clustered indexes onto columns that don't fragment as fast. It needs a lot of thought and analysis, but may help.
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
September 15, 2008 at 8:52 am
Richard McSharry (9/15/2008)
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
September 15, 2008 at 8:49 am
Ah. That's reinitialising the backup file, removing (overwriting) any backups that were present in the file before. It's not touching the database's log itself.
Personally I'm not fond of writing multiple...
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
September 15, 2008 at 4:39 am
Just one.
There would probably be only one for the following three queries
Select columns from tables where id = 3
Select columns from tables where id = 7
Select columns from tables...
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
September 15, 2008 at 4:17 am
I still don't understand what you mean by initialising the log. It's not a general SQL term for anything associated with the log. LSNs (Log sequence numbers) are used internally...
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
September 15, 2008 at 4:11 am
SELECT DISTINCT FromLocation, ToLocation FROM ...
will get you all of the unique combinations of the two. Is that what you want, or are you looking for just the values 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
September 15, 2008 at 3:57 am
james.easton (9/15/2008)
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
September 15, 2008 at 3:32 am
For clarity, the problem was originally reported here -
http://www.sqlservercentral.com/Forums/Topic560965-391-1.aspx
I'm more surprised this survived all the testing that was done on 2008. Seriously, in all the automated tests that were...
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
September 15, 2008 at 3:27 am
Update stats isn't needed (and can be counter-productive) if a full index rebuild is done. Update the stats only of tables that have been reorganised.
What exactly do you mean by...
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
September 15, 2008 at 3:10 am
The performance of adhoc SQL and Stored procedures is pretty much the same. What procedures give you is better plan cache reuse (and if your server has lots of memory...
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
September 15, 2008 at 3:09 am
Could you be more specific please?
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
September 15, 2008 at 1:57 am
Viewing 15 posts - 44,491 through 44,505 (of 49,552 total)