Viewing 15 posts - 1 through 15 (of 37 total)
You should put forward your issue in more details.
If you meant that your SQL Server cannot use all memory on the server, you can check memory consumption in windows...
October 9, 2012 at 12:59 am
Nops. The number I tell you is for SQL Server, not alll windows threads. go to task manager, then "processes", and select "select columns" from the "view" menu. then you'll...
July 28, 2012 at 10:53 pm
Ooops! There's a problem! I meant 880 worker threads, not 80.
When you go to task manager and you add "threads" option, then you see what I meant. SQL server...
July 28, 2012 at 3:42 am
Dev (12/5/2011)
LutzM (12/4/2011)
Would the fact count, that a query with a WHERE clause that covers more than one partition might run significantly slower...
December 7, 2011 at 1:48 am
Perry Whittle (10/10/2011)
parissa_bakhshi (10/10/2011)
So in either way, if you use CNAME or A recore, you shall change the orriginal A record IP address.
this is incorrect.
The CNAME record does...
October 10, 2011 at 11:50 pm
As I know , for GEO clustering, you should use VLANs between sites, you can do this using site-to-site VPN. In this way you have a single domain between sites....
October 10, 2011 at 7:14 am
Oh, so if this is the problem, I don't think using CNAME solves the problem. To find the problem , let's try step by step. when you changed the names,...
October 8, 2011 at 7:08 am
Think it's not a real cluster when you have different network names. What was the reason for using different network names for SQL resources? You can install a new sql...
October 8, 2011 at 6:46 am
Sure, I 'll use multi pathing. But this is a test procedure. Then if I encountered no problem, I 'll Use fiber. But it seems that it's slower than standalone!...
August 29, 2011 at 3:06 am
Would you please explain more?
What I know is that "clustered indexes" and "sql server clustering" are two completely different concepts!
August 29, 2011 at 2:26 am
I don't Use multipathing. Just a single 1 Gbps link. The initiator is microsoft iSCSI initiator and the target is starwind. I monitored network, because I thought the problem is...
August 28, 2011 at 11:17 pm
I know for sharepoint 2007 , you need to use "distributed transaction coordinator" service.
August 28, 2011 at 7:07 am
Many thanks, but this is nothing more than link server!
July 31, 2011 at 11:53 pm
Hello,
You told not to use Link Servers! Because I have performance issues on my server because of having many databases, then I want to seprate them, since they need...
July 31, 2011 at 8:39 am
I have one large file. An script has no advantage over SQL this way.
July 27, 2011 at 9:01 am
Viewing 15 posts - 1 through 15 (of 37 total)