Let me re-phrase the question. The Taskpad view in EM shows a list of files in the database and how much space is used in each file. I am wondering...
Is there a way to tell how much free space there is in a file besides using the EM task pad view?
When I ran "select * from sysprocesses order by waittime desc" RESOURCE_QUEUE is the highest waittype. Most of the documentation I've found on this...
Does anyone know of a good resource for how memory is allocated in the non-AWE space for SQL 32-bit? I'm looking for limits on how much memory can...
I'm bcp'ing data from one SQL 2000 database to another SQL 2000 database. They're basically the same database just one has an older dataset than the...
I have a table called TblA with a column named Col1 of type INT. I'd like to add the IDENTITY property to Col1. Can someone please show me the...
That is what I thought. But when I ran the following test the size of tempdb grew. DECLARE @tmpTable TABLE(cola CHAR(1000), colb CHAR(1000), colc...
Are table variables like Declare @Table1 Table(cola int) stored in TempDB? BOL isn't very clear...
The log file is 1 GB for both dbs and set to unlimited growth. I only run the test for 15 min. so there is no log file growth. (Simple recovery...
Thanks for your responses. This is an isolated test (no triggers or other table constraints...). For this test I've placed the tempdb files on the...
I'm looking for an explanation on the varying levels of insert performance I'm observing. I've got an 4x700MHz, 4GB RAM, test server with an 8-disk...
Does the filegroup that contains these objects have multiple files?
I would suggest looking at the Performance Monitor topics on the home page of this website. Beyond being a hardware bottleneck you could have...
Does the applciation make heavy use of cursors? Seeing that the cursor cache hit ratio is so low perhaps you want to look at modifying the "Cursor...
Bob, Interesting topic... Is the counter you're talking about is the SQLServer:Cache Manager object, Total instance, Cache Hit Ratio? If so I am...
Everyone suggested very valid software/design solutions to the problem. Perhaps there could be a I/O bottleneck? I would implement the changes...
You could also query the sysprocesses table and check what the wait types are. If you see pagelatch wait types when you execute: select * from...
Thanks for the feedback. Its always nice to hear what others are reading/thinking.
Actually I don't really want to call a stored proc within a view. Someone asked me if it was possible and I could not think of a way so I posted...
Nathan, Thanks for your tip!
Separate names with a comma.
