Search results for query: *

Yes, I am missing the icon status, the circle is there, just empty. I have some more information. I realized that MAP installed SQL 2008 express in order to run. That is the only instance that is showing started. I no longer am using MAP on my machine, so I removed it. I also removed the...

I have an issue that I've been scratching my head with the past few days. Just recently, all my registered servers no longer show the started/stopped status in SQL Server Management Studio. Even when I connect, I can browse the database fine, but again, the icon is empty. (This also includes...

In my process of getting the screenshots, I wasn't able to access the forum this morning. I dug a little deeper focusing on the execution plan and decided to remove parallelism which seemed to be the difference on the new server. sp_configure 'max degree of parallelism', 1 go reconfigure with...

I ran the index tuning wizard both on the query in question and on a profile trace of activity. Both came back with 'No index recommendations for the workload and the chosen parameters.'

I know that it is not being read from the cache as opposed to the old server, that is why am I puzzled. I was hopeful the types of reads would help lead me towards a solution. Again, same database/'better' hardware (even though I understand the limitations of SQL 2000 Standard) SP4 (8.0.2039)

Again, I'm only querying from a view. Maybe this information will help regarding the IO stats: OLD SERVER SQL Server parse and compile time: CPU time = 0 ms, elapsed time = 0 ms. SQL Server Execution Times: CPU time = 0 ms, elapsed time = 0 ms. SQL Server parse and compile time...

Thanks for the replies...I'll expand info and hopefully touch on suggestions. Both systems are x86. OS loaded local on local SAS disk RAID 1. DATA/LOGS on separate LUNS carved from an Equallogic iSCSI SAN RAID 5. Same setup as before. The plan was to move to SQL 2005 Standard when the new...

I have a client that just migrated to a new 'beefy' system for a SQL 2000 application, SQL 2000 Standard. The issue is that basic SQL queries are now taking 10x as long to generate results. What once took 10 seconds takes 100 seconds. Overall performance generally seems to be sluggish. The...