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...
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
Back up database
Clean up history
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.
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...
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.
I have a table (the table is simplified to show the specific issue)
CREATE TABLE Messages(
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...
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...
I just noticed this message in the SQL-Server Agent log.
 16 processor(s) and 2048 MB RAM detected.
We have 12GB of ram and 4...
Is there any difference between these indexes:
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...
I came across a session called "running a megasite on microsoft technologies", which focues on the scalability issues that comes with a large...
I have a query like this.
@myusername, username, age
gender = 'female'
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.