Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2009-11-11 : 08:59:14
|
| Hi experts, Here are someinterview questions, kindly share your answers.How can i see resource database in 2005How would you troubleshoot a slow running query/slow running server? What jobs would you run for maintenance? ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
govthamb
Starting Member
27 Posts |
Posted - 2009-11-12 : 03:31:59
|
| Please check this link for resource db.. http://msdn.microsoft.com/en-us/library/ms190940(SQL.90,lightweight).aspx |
 |
|
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
Posted - 2009-11-12 : 08:17:13
|
| The Resource database is a read-only database that contains all the system objects that are included with SQL Server 2005. For every server with the same pacth level has the resource database will be same. Say for all SP1 servers will have the same Resource db. We can see that only as flat files. ie., mssqlsystemresource.mdf & ldf files.Regarding slow performance, Check the server IO, memory usage. Check if SQL is having any memory pressure. Also check for long running queries from sysprocesses or a simple server side tracing. Try troubleshooting queries, checking the execution plan & indexes.Thanks,Krishnawww.SQLServer.in |
|
|
|
|
|
|
Interview questions