Rambler (10/29/2010)

---

Hi. I have a table that has a column which contains names of all databases on the server.

How can I find out transaction log name for every database in...

Thanks a lot Gail. Got my answers 🙂

the DBID is 32767 which is resource db i think. is the SP created in memory as resource db is read only? i dont know if that happens.

Hi Gail, I ran this query.

select

highest_cpu_queries.plan_handle,

highest_cpu_queries.total_worker_time,

q.dbid,

q.objectid,

...

I checked the code behind sp_dbmmonitorupdate system stored procedure which is called every minute by the mirror monitoring job. The SP has the following code within it:

exec @retcode = sys.sp_dbmmonitorMSgetthelatestlsn...

you should leave checkpoint to sql server.

Checkpoint is called by sql server at certain frequency so that only that much dirty pages remain in memory which sql server can recover...

It may grow out of control where in there is sudden import of huge amount of data and some other scenario. OP needs to keep an eye on everything(better to...

get a faster disk:-)

are you doing it when the server is idle?

Another link says dbmirroring wait are coz the threads have nothing to do and hence they wait. This is in contrast to what was written in a diff thread that...

you probably need more disk space. or put the log file on a drive having ample free space for the log file to accomodate its growth.

can you zip the backup file on server, unzip it to a different location on the server itself and run restore verifyonly? If this is success, it will rule out...

I ran Glen Barry's code and found that about 95% of waits is due to dbmirroring_cmd wait type.

dm_os_wait_stats gives this figure.

wait type ...

looks like the backup file got corrupted while zipping it or while transferring to ur machine over the network.

can u try repeating the process.

jonathan.rottanburg (10/27/2010)

---

Hi,

We recently built up a new SQL 2005 server and then attached the pthprod databse to it, pthprod was from a 2000 SQl install. we had an issue where...

http://www.sql-server-performance.com/articles/per/index_fragmentation_p1.aspx

http://www.mssqlcity.com/Articles/Adm/index_fragmentation.htm

Though these links relate to 2000, they explain why fragmentation occurs and use dbcc showcontig to find fragmentation; in 2005 and above you have the dmv sys.dm_db_index_physical_stat which you can...