Thanks, Luis. I AM using Perfmon to monitor SQL Server. I was asking about the odd values I see in Task Manager on this server and why those values...
Hi, I have SQL Server 2005 STD running on Windows Server 2003 and performance is slow at times. RAM: 8 GB 4 Processors Paging File/Virtual Memory...
Satya, I have far too many deadlocks to have to walk thru the logs manually. That's why I configured a Profiler Trace to write the information into a...
hi experts, My 2005 database is experiencing lots of transaction deadlocks. I want to run a Profiler Trace that will collect the Database Name,...
Thanks for the suggestion, Frank. This happens to be a test server so I can bounce MSSQL services without causing too much pain. Please consider...
Hi everyone, I'm using (2005's) sys.dm_db_missing_index_details DMV to identify columns that should have indexes. It returns a lot of extraneous...
Hello everyone, In 2005, has anyone found a good way of finding the names of Tables that full scans are occurring on? And maybe even the SQL code...
Danny, I have had NO issues after installing SP3 . On 6 database servers - all is good. I followed up by installing Cumulative update # 2 after SP3....
Thanks, Louis. Avg Disk Queue Lenght is high - at a value of 71. But thats for Physical Disk We have SANS and are using Pillar storage. I know if...
hi everyone, I'm running 2005 on a Windows 2003 server and I suspect I have a bottleneck in disk I/O. I have read that if I run Diskperf -ye (at...
hi all, My question is for 2005. I have a table that contains information about some tables: table name, number of rows, index name and...
Here is an update on my situation. Yes, I do run regular T-Log backups - every 2 hours. I recently re-ran the maint plan again after disabling the...
Thanks Ram. Unfortunately, I cannot lock-out the database. It is used 24 x 7. You may have a point though with the T-Log backup job which runs...
I am not using replication or log shipping. Yes database is in FULL recovery mode. Logs are backed up every 2 hours. Thanks DavidFarr for your...
hi experts, This is 2005 SP2 My Maint plan spun out of control and the log became full before the m plan completed. The db data size is 8 GB and...
Thanks for your ideas, Satya. This is what caused it to not select any rows...... I had "Use master;" as the first line. I removed that line and...
Satya, I'm exporting to a text file, so I don't think referential integrity could be the casue of not selecting any records. My input table is in...
Thanks for the suggestion, Satya. Yes, the source columns match the target columns exactly - even the dataTypes are the same. In design Mode, the...
Hi experts, Using 2005's Export wizard to do a quick, ad-hoc report. When I run the query it does select 15 rows, but the same query inside the...
Thanks for the code to calculate my compression ratio, Satya. And yes, it is a very good thing to be exceeding the expected results. John
Separate names with a comma.
