Viewing 15 posts - 48,301 through 48,315 (of 49,552 total)
It's not quite clear from what you said. Do you think profiler's showing too many events, or too few?
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
October 27, 2007 at 6:30 am
What transfers/sec is good depends on the hardware you have. Diffrent disks and disk configs have different max capacities. Maybe someone else will be able give some figures.
Page splits/sec should...
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
October 26, 2007 at 10:20 am
There's a fairly well-known issue around SQL and hyperthreading. I know it sounds strage, but see if you can get the hyperthreading disabled and see if the ETC improves at...
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
October 26, 2007 at 10:09 am
Put an order by on your select and your delete, or there's no guarentee that you'll get the same records. Especially since you have a nolock on the select.
Without an...
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
October 26, 2007 at 8:06 am
Has the amount of data been transfered increased? Has the size of the tables increased?
Is this ETC across networks? If so, is the network handling the load?
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
October 26, 2007 at 8:04 am
I would run profiler over the time that the ETL process runs. Capture the SQLBatchCompleted event (under T-SQL) and the RPC completed event (under stored procedures)
That will give you a...
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
October 26, 2007 at 7:18 am
Are the indexes the same between the original and new server? By default, nonclustered indexes are not copied when a table is replicated.
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
October 26, 2007 at 6:56 am
The problem with writing an article on indexing, is that the 'best' indexes for a table depend on a large number of factors, and th table structure is probably 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
October 26, 2007 at 4:27 am
For the exec plan cache query, run this in the db that has the stored procs you're interested in. DB will need to be in compat mode 90
SELECT creation_time, last_execution_time,...
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
October 26, 2007 at 1:07 am
If the procedure has been executed recently, it may be in the execution plan cache. If that's the case you can find the time the plan was created and 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
October 26, 2007 at 12:55 am
This works in SQL 2005, but ot in SQL 2000. In 2000, the only ways to do this are dynamic SQL or RowCount
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
October 26, 2007 at 12:36 am
Catcha (10/25/2007)
Thanks for the solution. It works perfectly. What is the function over (Partition BY) does? What is the different between Over(Partition By) and Over(Order by).
Partition by is like grouping...
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
October 26, 2007 at 12:19 am
My pleasure. Glad I could 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
October 25, 2007 at 10:02 am
Jeff Wikle (10/25/2007)
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
October 25, 2007 at 8:44 am
Now you know the power of a well-placed index. 😀 Glad I could help.
As for your date. Easiest way is to do a range query on the logdate. We can...
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
October 25, 2007 at 8:05 am
Viewing 15 posts - 48,301 through 48,315 (of 49,552 total)