Hi I have been thinking of replacing our san that has 50 15k disks with either a ssd card like fusionio (http://www.fusionio.com) and ramsan...
Hi If we have 18 15k disks in a raid 10 setup for sql-server data using ibm ds4300 (without turbo). We are currently seeing around 17,3 as avg disk...
I have deleted ~2 million rows in the table sysmail_mailitems in the msdb database. The table was about 35gb, but now after the delete it's still...
Hello, we have a problem that seems to be fixed. in kb 937343 http://support.microsoft.com/kb/937343 a fix is available. That fix seems to be part...
Hello. We have setup a maintenance plan in the following order Check db integrity Rebuild index Back up database Clean up history Maintenance...
Hello. I have a query that takes 1,5second to execute, but only 150ms of CPU. The query is quite simple, just one where statement against a clustered...
I often read about that the optimal would be that the whole database could fit in RAM. Lets say I have a dabase that is 100gb. I have 20gb RAM. Its...
Hello! I noticed that one server had twice as many transactions/sec in the temp-db than in the actual database. How is this possible, and how can I...
Hello, how does sql-server calculate the "query cost (relative to the batch)) in sql server management studio in the execution plan-tab? I have a...
Hello I am trying to denormalize multiple tables and create an index to increase the performance of a search function that we have. The problem when...
Hi, how will it affect performance if you nest stored procedures? I am thinking in terms of query plans and cache and that sort of things. Lets say...
Hello! I have a table (the table is simplified to show the specific issue) CREATE TABLE Messages( FromUserId INT, ToUserId INT Topic...
Hello! I have an array in my SAN that have high % disk time (avg 70 or so), but booth the avg. disk read queue length and the avg. disk write queue...
Hello! I want to send an email when a job fails. It seems like I need to configure an outlook account to be able to do that? Is that really...
Hello! I just noticed this message in the SQL-Server Agent log. [310] 16 processor(s) and 2048 MB RAM detected. We have 12GB of ram and 4...
Hello. Is there any difference between these indexes: (Id, RegisterDate) (Id) when you have a query like this: SELECT Id FROM Users WHERE Id = 1...
Which is the easiest or best way to find out how often all the indexes in a specific table are used? I want to use this to be able to remove unused...
Hello! I came across a session called "running a megasite on microsoft technologies", which focues on the scalability issues that comes with a large...
Hello! I have a query like this. select top 10 @myusername, username, age from users where gender = 'female' order by...
When you use exec() it will almost always generate a new execution plan (never reuse an execution plan), while sp_executesql will cache and reuse an...
Separate names with a comma.
