Search Results | SQL Server Performance Forums

Optimal number of files per filegroup for an Index

Thread by: Tom Leykis, Dec 23, 2007, 1 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

I have a 4x quad core. Both Data & nc Index files are on the same 12-Disk Raid 1+0, each within their own separate filegroups. I have the data...

I can put either Tempdb or Trans Logs on Raid 10, which should it be?

Thread by: Tom Leykis, Dec 15, 2007, 3 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Using the following configuration, which one gets the Raid 10 on the server? Server: Raid 1 for the OS 4-disk Raid 10 (temp db or trans logs?) Drive...

Should index have its own filegroup with 1 file per processor core as well?

Thread by: Tom Leykis, Dec 12, 2007, 2 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Inside my db's filegroup I have one file per processor core. Should I also create a separate filegroup for index and create one file per proc core in...

New 4x quad core setup, need Raid suggestions

Thread by: Tom Leykis, Dec 10, 2007, 1 replies, in forum: SQL Server 2005 Performance Tuning for Hardware

I have no experience with Sql 2005 and am finally jumping into from Sql2k. Setting up a brand new install for client of mine and would love to hear...

How do pass Select results into sproc

Thread by: Tom Leykis, Apr 1, 2006, 6 replies, in forum: T-SQL Performance Tuning for Developers

What is optimal way to do this? I have table variable with one row of data. I need to pass the columns into a stored procedure. so lets say my...

CPU at 100% & Ram not used up

Thread by: Tom Leykis, Apr 1, 2006, 3 replies, in forum: Performance Tuning for DBAs

Have SQL 2000 running on a 3-month-old Dell 6850 w/220 drive shelf, Dual 3.1 Xeon, 4G Ram. The machine is a little monster and runs well. We hit is...

Server Management Studio Open File

Thread by: Tom Leykis, Mar 20, 2006, 7 replies, in forum: SQL Server 2005 General DBA Questions

Sorry for posting such a silly question, but for the life of me I cannot figure this one out. In Server Management Studio, when I have a Query tab...

High volume Insert on TEXT column

Thread by: Tom Leykis, Jan 5, 2006, 4 replies, in forum: Performance Tuning for DBAs

SQL 2000 on brand new Dell 6850, Quad Xeon, 3.1Ghz, 4G Ram, 220S Drive shelf U320's Have large amount of xml coming into SQL Stored Procedure...

OPENXML No CDATA having parse issues

Thread by: Tom Leykis, Oct 22, 2005, 1 replies, in forum: General Developer Questions

I'm trying to parse through an xml doc via OPENXML that is passed into a stored proc. The xml is not using CDATA and the text in some of the nodes...

Creating Global Variable on machine

Thread by: Tom Leykis, Oct 20, 2005, 2 replies, in forum: General Developer Questions

I have a table that gets changed maybe once every two months. I have several stored procs that call this table via a JOIN all day long (more than...

Query analyzer weirdness going on

Thread by: Tom Leykis, Oct 14, 2005, 6 replies, in forum: General DBA Questions

Has anyone ever seen this? On a brand new install: Windows XP Pro Sql 2k sp3 I have about 6 Enterprise Mangers plugged into an MMC Console, all...