This is the fast way to get a count of all the data in the tables in a database…
[TableName] = so.name,
[RowCount] = MAX(si.rows)
FROM sysobjects so, sysindexes si
WHERE so.xtype = ‘U’
AND si.id = OBJECT_ID(so.name)
GROUP BY so.name
ORDER BY 2 DESC
Here’s this week’s challenges….
1. Ran SQLIOStress test on all servers in one environment – here’s an overview of what it does
– I did graph the results and found that although the configurations where nearly the same on two of our top end servers – the speed was slightly better on one. I’m still trying to get to the root cause.
2. Four SQL 2005 installs on non standard servers in one of our environments.
– one had reporting services with it
3. Log Shipping – I sent up two environments with Log Shipping on four primary servers.
- Two had native log shipping
- Two has SQL Lite Speed Log Shipping
4. A few performance issues that I will post about later.