Viewing 15 posts - 45,361 through 45,375 (of 49,552 total)
Where was the table you were saving to?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 30, 2008 at 12:59 am
webrunner (7/29/2008)
I happened to be running a T-SQL Duration profile trace yesterday. Could this be the performance info on that trace?
Depends. Were you running it to file or to table....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2008 at 2:40 pm
Rename the table and see who complains? 😀
Seriously, there's no easy way. You'll have to trace the server for a while (a day, a week, a month) until you're happy...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2008 at 1:43 pm
Not exactly.
SQL will use the index that is most optimal for the particular query. If none of the NC indexes are useful, it will use the cluster. That's probably not...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2008 at 1:41 pm
Don't worry about self-blocking. It's usually short lived and just means that pieces of the query are waiting internally for other pieces.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2008 at 1:30 pm
Less activity on the test server. Is your query having to wait for locks? Wait for IO? Wait for time on the CPU? All are possible and more likely on...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2008 at 1:23 pm
Do you have anything else running on this server? Any antivirus or other IO filter drivers? The sec/write is way too high, but the writes/sec aren't. Doesn't make sense.
Could you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2008 at 1:17 pm
SQLServerLifer (7/29/2008)
GilaMonster (7/29/2008)
Haven't we all. 😉 It's a good place to start, nothing more.
That's why I prefaced mine with the ever popular disclaimer "It depends" 🙂
Last time I gave...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2008 at 10:24 am
Windows authentication is best. It's more secure than SQL authent. That said, their windows accounts only need access to SQL, not to the server itself. They don't need any rights...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2008 at 10:23 am
To extend your example, if there's a frequent query for all people living in a certain city, then I would probably want an index on the Address table on City...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2008 at 10:18 am
It's not really possible to say where that comes from. It doesn't look like a system query, but that doesn't mean it isn't.
I would suggest you set up a server-side...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2008 at 9:57 am
SQLServerLifer (7/29/2008)
Gail, while I tend to agree I've run into some very bad choices at client sites.
Haven't we all. 😉 It's a good place to start, nothing more. I...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2008 at 9:51 am
abhishek.khanna (7/29/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2008 at 9:34 am
It is advisable to create nonclustered indexes on foreign keys, though whether the index should be just on the foreign key column, on other columns as well and whether it...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2008 at 9:28 am
Oooh, you have a lot of work ahead of you. Some suggestions:
Uninstall the client tools from all of the servers. Servers don't need management studio and books online on them.
Change...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2008 at 9:23 am
Viewing 15 posts - 45,361 through 45,375 (of 49,552 total)