We have NetApps storage systems and it has been just recently rolled out for file services. The idea is to roll it out for SQL Server storage as...
Both instances are the same - SQL2K Enterprise Edition, SP3a plus the same server options apart from more RAM allocated to the instance in question....
Thanks. Any ideas why SQL Cache Memory (KB) is reported to be 1.5 mb when it is certainly bigger than this? Another related puzzle. On my other...
I've noticed that with some other tables, only the indexes are cached. If it were possible to know more about what rules are used by SQL Server 2000...
I posted a similar question last week but things have moved on a little so a new post is appropriate... I've dropped some unwanted indexes and added...
It's SQL Server 2000 Enterprise Edition on Windows Server 2000 Advanced Server. Using the /3GB /PAE switches in boot.ini . So, AWE is no in the...
Thanks for that. Tom already plugged the article and I found it very useful. In this case, I found one table plus one of its secondary indexes...
Having done some analysis of what tables were being loaded into cache on our production server, I was a little concerned that some of my own...
Yes, I'm sure you're right about tempdb. I'm just not sure what I can do about it as I've already got it on it's own RAID 1 drive. It's SQL Server...
Thanks for both replies. I can confirm that memory is dynamically allocated... I just set the max on each instance so it doesn't compete with the...
Well, there are some performance issues although it's hard to know if they are down to inefficient application code or down to memory configuration....
I've been monitoring PageLife Expecency for one of our production SQL Server 2000 instances. I read somewhere that the minimum level is 300...
Data volume is identical in test as production - databases restored from production. I carried out tests on production when it was quiet and the...
I support a number of databases that are developed and tested on dev/test servers before being released to a production server. I'm running SQL...
More... I can not replicated this problem on other servers. No idea what's causing this behavior though. Clive
Ok, I have narrowed the problem down a bit. If the text field is populated directly by a select from another table, it works in QA and in a JOB....
I have some code that generates some XML and inserts it into a text field in a table. The datalength of the text in the field can vary but the...
Adriaan, that's a good point but I went through this last year with the server management team and made sure that the db files were excluded....
No differences made re. dropcleanbuffers freeproccache. Ran the query several time after. Memory settings are unchanged and they are properly...
The execution plan shows no table scans on the table (it scans on the temp table but that isn't an issue as the temp table is just for the simplified...
Separate names with a comma.
