Home / user-9826

Ra Osolage's questions

Martin Hope
Ra Osolage
Asked: 2009-12-05 13:50:55 +0800 CST
  • 0

We have a vendor app that has a SQL Server 2005 database. During data entry, app writes data to a table that has no clustered indexes on it. It has a number of indexes on the table, though.

I used the Maintenance Plan wizard to rebuild the indexes on that table.

During performance testing, we started running into deadlock issues. The deadlock graph shows that this particular table without a clustered index is the one being contended for.

I then used the Maintenance Plan wizard to rebuild the indexes with fillfactor 80. No deadlocks now. Any ideas why this fillfactor would make a difference?

indexes
Martin Hope
Ra Osolage
Asked: 2009-11-19 14:04:52 +0800 CST
  • 2

Does anybody know of any good information out there about mount points and SQL Server? I have like 80 databases to create on one SQL instance and what I'm trying to figure out is whether we'd benefit from having a mount point for each database. Or should I just do one mount point for data files, one for transaction logs and one for tempdb? Of course, all of this is backed by high-end SAN...

Thanks for any advice or links you can offer!

sql-server
Martin Hope
Ra Osolage
Asked: 2009-10-03 09:32:13 +0800 CST
  • 2

We run our SQL Server services using a low privileged domain account. That account is NOT a local admin on the OS. Only access I give the user account is assigned during install of SQL: full control over its mount points and then everything else is granted by the SQL Server 2005/2008 installer.

I need to create a linked server in SQL Server 2008 to an ODBC data source. So I remoted into the computer using my domain account, which is part of a group that DOES have local admin privs to the OS. I created a system DSN and configured it to connect to another SQL Server. The DSN works perfectly when I test it. However, when I try to create the linked server, I get an error.

It appears to me that the DSN is invisible to the domain account that SQL Server is running as. It seems that this problem is only happening to me on Windows 2008 servers. Does anybody know whether there's anything that you need to do after creating a DSN to make it visible for other users to access?

windows-server-2008