| Thread | Last Post | Replies |
|
| Mounted Volumes vs drive letters | 30 May 2008 04:52 GMT | 3 |
In the world of SQL server, which is better to use for logs and data files?
Mounted Volumes or Drive letters? Does it really matter either way? Is there
a performace benefit with one over the other?
thanks
|
| Blocked process report : wait Resource | 23 May 2008 16:25 GMT | 2 |
I 've used sql profiler to detect locking processes.
In profiler I see the locked processes appear but the content of <inputbuf>
is 'select 1' and the waitresource is "KEY: 5:72057594384678912
(010069b70edb).
|
| Different execution plans on 2 different servers | 22 May 2008 14:37 GMT | 2 |
This my problem, the execution plan is different on server (server1) than
another server (server2) on the same database shema and the same data.
MSSQLserver 9.0.3042 is installed on the server1.
MSSQLserver 9.0.3054 is installed on the server2.
|
| Different execution plan on 2 servers with same database, same dat | 22 May 2008 12:10 GMT | 2 |
This my problem, the execution plan is different on server (server1) than
another server (server2) on the same database shema and the same data.
MSSQLserver 9.0.3042 is installed on the server1.
MSSQLserver 9.0.3054 is installed on the server2.
|
| 64 bit SQL Server 2005 Memory | 16 May 2008 01:12 GMT | 2 |
I have a x64 bit installation of SQL Server 2005 Developer edition on windows
server 2003. The box has 8gb of memory and I've set the max memory to
2147483647 MB in the properties whenever I take a look at task manager the
Memory usage for sqlservr.exe is at about 117,236KB.
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread